repeat without change
 

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

repeat without change
 

=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" wrote in
message ...

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

repeat without change
 

Try $L$1
Regards,
Alan.
"spxer" wrote in
message ...

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

repeat without change
 

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

repeat without change
 

thanks I understand now.


--
spxer
------------------------------------------------------------------------
spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
View this thread: http://www.excelforum.com/showthread...hreadid=568643