| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
How can I drag a formula without incrementing both of the cell values stated
in the formula? This is the result I need: =A4*D125 =A5*D125 =A6*D125 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
"sdmccabe" wrote:
How can I drag a formula without incrementing both of the cell values stated in the formula? This is the result I need: =A4*D125 =A5*D125 =A6*D125 Change D125 to $D$125. One way to do that: click on the cell, click on D125 in the formula, press F4 until you see $D$125. You might also want $A4 (using F4 again) if you want to be able to drag the formula across the same row and retain A4. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula help
Great - thanks.
" wrote: "sdmccabe" wrote: How can I drag a formula without incrementing both of the cell values stated in the formula? This is the result I need: =A4*D125 =A5*D125 =A6*D125 Change D125 to $D$125. One way to do that: click on the cell, click on D125 in the formula, press F4 until you see $D$125. You might also want $A4 (using F4 again) if you want to be able to drag the formula across the same row and retain A4. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Hide formula | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Linear Mode
