How do I multiply an entire page of formulas by one multiplier?

J

Jami

I have multiple worksheets with different formulas in each cell. i want to
take all cells on the worksheet and multiply them by a single multiplier.
Each answer would vary as each cell has a different formula. Is this
possible?
Thanks!
 
M

Myrna Larson

Put the multiplier in a cell. Edit/Copy that cell. Then select the cells to be
modified, and Edit/Paste Special and select the Formulas and Multiply options.
 
K

Ken Wright

If you put the multiplier in a cell and then in any other cell reference that
cell absolutely, eg in cell A1 put your multiplier and then in cell B1 put
=$A$1, now copy cell B1, select all your data and do Edit / Paste Special /
Multiply & Formulas, you will now see that each and every cell ends in *($A$1),
and so whatever multiplier you put in cell A1 will now affect all other cells.
This allows you to to vary them but keep the original values that underly those
cells, and simply setting the multiplier back to 1 allows you to see the
original data.
 
R

Ragdyer

To multiply by 2 for example,
Enter 2 into an unused cell.
Right click in this cell and choose "Copy".
Select all the cells that you wish to increase.
Right click in this selection and choose "PasteSpecial".
Click on "Multiply", then <OK>.

Where there were only numbers in cells, you'll see a new number increased by
2.
Where there were formulas in the cells, you'll see a "*2" appended to the
existing formulas.

However, you might have error messages returned from some of your formulas
if the original formulas didn't equate to a numeric value.
 
Top