constant multiplier

[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?

 

[T. Valko]

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

 

[Lin242]

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.

 

[T. Valko]

If you want to increase by 2% then enter 1.02 as the multiplier.

 

[Mike H]

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