Thread: repeat without change
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
spxer spxer is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote