Thread
:
Need to add a certain percentage to a column of prices
View Single Post
#
3
Glowinafuse
Junior Member
Posts: 11
Okay, I am new to this, and I am trying to understand. But where do you put that formula? how... I need to learn this real quick for something at work.
Quote:
Originally Posted by
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
"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
Reply With Quote
Glowinafuse
View Public Profile
Send a private message to Glowinafuse
Find all posts by Glowinafuse