repeat without change

[spxer]

I am trying to repeat a column with the series:

=L3+($L1*AF4)+($L1*AF4*20%)
=L4+($L1*AF5)+($L1*AF5*20%)

I have tried select and drag and copy and paste. Every way I try
changes the $L1 to $L2, $L3 etc. How do I repeat without changing the
L1? I thought the $ sign is supposed to accomplish that. Thanks

 

[Bob Phillips]

=L3+($L$1*AF4)+($L$1*AF4*20%)

you are making the column absolute not the row

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Alan]

Try $L$1
Regards,
Alan.

 

[Pete_UK]

You need to put the $ in front of the 1, i.e.:

=L3+($L$1*AF4)+($L$1*AF4*20%)

If you are copying down, the $ in front of the L is not really
necessary.

Hope this helps.

Pete

 

[spxer]

thanks I understand now