Excel Calculations

  • Thread starter Thread starter Bill R
  • Start date Start date
B

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