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 edit>paste special and check
multiply,
if you use the =1+17% you probably need to reformat the cells into either
currency or general
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 Edit>Pastespeciaol, and click the
multiply button, then OK
--
HTH
RP
(remove nothere from the email address if mailing direct)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
