Excel Calculations

[Bill R]

I have a series of variable values in one column. I also have a fixed value
in one cell. I want to multiply all of the variable values by the fixed
value. How do I copy the formula for one calculation down the entire adjacent
column without Excel changing the cell number that contains the fixed value.

 

[Jellifish]

If you have values in A1 to A10 and want to multiply all those values by B1
then put the following formula in C1 and copy down:

=A1*$B$1

 

[Gord Dibben]

Without any formulas........................

Select the cell with the fixed rate.

Copy that cell.

Select the range to change and Paste Special>Multiply>OK>Esc

But you may want to have the formulas so's you can change the fixed rate for
what-if.

See other posts for cell referencing.


Gord Dibben MS Excel MVP