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.
|