constant multiplier
 

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

constant multiplier
 

Try this...

Enter your multiplier in a cell
Copy that cell: EditCopy
Select the range of cells you want multiplied
Then: EditPaste SpecialMultiplyOK
Delete the multiplier


--
Biff
Microsoft Excel MVP


"hugoalegria" wrote in message
...

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

constant 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.
--
Lin242


"T. Valko" wrote:

Try this...

Enter your multiplier in a cell
Copy that cell: EditCopy
Select the range of cells you want multiplied
Then: EditPaste SpecialMultiplyOK
Delete the multiplier


--
Biff
Microsoft Excel MVP


"hugoalegria" wrote in message
...

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

constant multiplier
 

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

--
Biff
Microsoft Excel MVP


"Lin242" wrote in message
...
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.
--
Lin242


"T. Valko" wrote:

Try this...

Enter your multiplier in a cell
Copy that cell: EditCopy
Select the range of cells you want multiplied
Then: EditPaste SpecialMultiplyOK
Delete the multiplier


--
Biff
Microsoft Excel MVP


"hugoalegria" wrote in message
...

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

constant multiplier
 

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

"Lin242" wrote:

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.
--
Lin242


"T. Valko" wrote:

Try this...

Enter your multiplier in a cell
Copy that cell: EditCopy
Select the range of cells you want multiplied
Then: EditPaste SpecialMultiplyOK
Delete the multiplier


--
Biff
Microsoft Excel MVP


"hugoalegria" wrote in message
...

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