|
As a variation on Ken's suggestion : Enter your multiplier value (say 5) into a cell (say D1). Then in the first cell of column C enter “=B1*D$1” - again omitting the double quotes. Then copy that formula down into all of the other relevant cells in column C. By using this approach you can simply change the value in cell D1 to any number that you like and your change will automatically affect all of the calculations in column C. Note that by using the dollar sign ($) in the formula the row number of the cell in which the multiplier value is entered (in this case 1) is made absolute with the result that the copied formulae for the first three rows in column C will read “=B1*D$1”, “=B2*D$1” and “=B3*D$1”.
|