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 |
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. |
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. |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com