| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find function | Excel Worksheet Functions | |||
| Macro to change Chart Range when inserting a column | Charts and Charting in Excel | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
| How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
Threaded Mode
