repeat without change

S

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
 
B

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)
 
P

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
 
Top