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)

"spxer" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> spxer
> ------------------------------------------------------------------------
> spxer's Profile:
http://www.excelforum.com/member.php...o&userid=37025
> View this thread: http://www.excelforum.com/showthread...hreadid=568643
>

[Alan]

Try $L$1
Regards,
Alan.
"spxer" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> spxer
> ------------------------------------------------------------------------
> spxer's Profile:
> http://www.excelforum.com/member.php...o&userid=37025
> View this thread: http://www.excelforum.com/showthread...hreadid=568643
>

[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 wrote:
> 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
>
>
> --
> spxer
> ------------------------------------------------------------------------
> spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
> View this thread: http://www.excelforum.com/showthread...hreadid=568643

[spxer]

thanks I understand now.