Need to add a certain percentage to a column of prices

G

Glowinafuse

I have excel 200. I am wanting to add a certain percentage like 20%
etc... to a column of prices. for example if the price on the colum
was 10.00 it would increase it to 12.00(20% increase).

Can this be done.

Please help...

Thanks in advance,

Glowinafuse :
 
A

Arvi Laanemets

Hi

a) With new price in new column (p.e. with price in cell A2)
=A2*1.2

b) When you want to overwrite old prices with new ones:
- Enter 1.2 into any free (empty) cell. Copy the cell;
- Select the renge with prices;
- from Edit menu, or from right-click drop-down, select Paste Special, and
select Multiply option. OK.
It's done!


Arvi Laanemets
 
Top