constant multiplier

  • Thread starter Thread starter hugoalegria
  • Start date Start date
H

hugoalegria

--
halegria
I have a spread sheet with multiple columns that need to be multiplied by a
constant number, is there a format or a formula that will allow me to drag or
do it all in one fell swoop as opposed to multiplying each cell?
 
Try this...

Enter your multiplier in a cell
Copy that cell: Edit>Copy
Select the range of cells you want multiplied
Then: Edit>Paste Special>Multiply>OK
Delete the multiplier
 
I am trying to do this same thing, but what I get is the actual dollar figure
of the percentage itself, it's not ADDING to each individual cell where my
totals are located (in dollar amounts). I don't need them added by column or
row, simply that each dollar amount within the cells is multiplied by 2% and
a formula that will continue that as new amounts are entered.
 
Hi,

When you say multiply by 2% do you literally mean that. For example 100 * 2%
=2.
for this your multiplier is 0.02

or do you mean Add 2% i.e. 100 + 2% = 102.
If it's the latter then you put 1.02 in a cell and copy it.

Mike
 
Back
Top