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
"Glowinafuse" wrote in message
...
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 column
was 10.00 it would increase it to 12.00(20% increase).
Can this be done.
Please help...
Thanks in advance,
Glowinafuse :)
--
Glowinafuse
|