Percent Increase
 

How do i increase multiple cells by using a percent formula?

One way, assume you want to add 17% to a rnage of cells, best might be to use
a help column and this formula

=A1*(1+17%)


copy down/across
that way you have an audit trail

otherwise put this formula in a cell

=1+17%

or just 117

copy the cell, select the range of cells, do editpaste special and check
multiply,
if you use the =1+17% you probably need to reformat the cells into either
currency or general


Regards,

Peo Sjoblom


"woody" wrote:

How do i increase multiple cells by using a percent formula?

In an empty cell, input your total multiplier, say 1.25 for a 25% increase.
Copy that cell
Then select all your target cells, go to EditPastespeciaol, and click the
multiply button, then OK

--

HTH

RP
(remove nothere from the email address if mailing direct)


"woody" wrote in message
...
How do i increase multiple cells by using a percent formula?