Adding a percentage to all fields...

U

Un4given

Okay, I have a pricelist which has thousands of computer products...
want to alter all the prices at the same time by percentage. So lik
if I wanted them all to be bumped up 10% it would take a $100 item an
make it $110. Or if I wanted to drop it -10% or somethin'. Get it?
How would I do that?

Seems to be difficult. :
 
J

JulieD

Hi

Not too difficult

in a new cell type 1.1 if you want to increase it by 10% or .9 if you want
to decrease it by 10% then copy the cell
then select all the cells that you want to alter and choose
Edit / Paste Special & multiply

click on the OK button

hope this helps - oh, please test first before applying to thousands of
products :)

Cheers
JulieD
 
A

Andy Brown

Okay, I have a pricelist which has thousands of computer products... I
want to alter all the prices at the same time by percentage. So like
if I wanted them all to be bumped up 10% it would take a $100 item and
make it $110. Or if I wanted to drop it -10% or somethin'. Get it?
How would I do that?

Seems to be difficult. :(
Click to expand...

For e.g. +10%, put 1.1 in a free cell & copy it. Select the range to mark
up, then Edit -- Paste Special -- Multiply.

Rgds,
Andy
 
P

Peo Sjoblom

If you want to have an audit trail you should use help columns and formulas
like

=A1*1.1 (increase with 10%)

=A1*0.9 (decrease with 10%)

otherwise put 1.1 in an empty cell, copy it, select the prices you want to
increase with 10% and do edit>paste special and check multiply

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
F

Frank Kabel

Hi
one way:
- enter 1.1 in an empty cell and copy this cell
- select your prices
- goto 'Edit - Paste Special' and choose 'Multiply'
 
A

Andy B

Hi

In an empty cell type 1.1 (for 10% increase)
Copy this cell, select your range and then Edit / Paste Special. ...
Multiply.
 
Top