Formula help

[sdmccabe]

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

 

[joeu2004]

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.

 

[sdmccabe]

Great - thanks.

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.