Calculating Percentages in Excel
You can work with percentages you don't have to use decimals, and it makes
it easier to read.
If the discount is 30%, and the original price is 2.57, then the discounted
price is
=2.57-(2.57*30%)
that is the price - (the price multiplied by the discount). You might want
to round it to 2 dec pl
=ROUND(2.57-(2.57*30%),2)
If the discount is 30% and the discounted price is say 2.99, then the unit
price, rounded, is
=ROUND(2.99/(100%-30%),2)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
" wrote in message
...
Hi
I have three columns as below
Unit Price ABC Company
Price EFG Company Price
Not Known 40%
discount 30% Discount
Not Known 20%
discount 30% Discount
I am getting a little confused because there seems to be in the Excel
help file different ways to calculate, and I keep getting different
answers!
I need to work out firstly what the Unit price is, and I need to work
it out from the discount given to EFG Company (ie 30%). From that,
once I work out the Unit Price I can work out what I will be selling
my goods at to ABC Company.
My problem is, I have never been good with maths and have been told
that just putting on 30% will not give me a correct answer, I should
use a decimal point ie 0.50 (which I think is 50%) or 0.70 for 30%.
Can someone help me here as I have messed about with this all morning
and got nowhere fast
Thanks
|