Calculating Percentages in Excel

[babypink2807]

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

 

[Mike H]

Hi,

Your column formatting got a bit mixed up when pasted in but if you want to
reduce a value by (say) 15% use this formula

=A2*(1-0.15)

Where A2 is the value you want to reduce
Simply change the 0.15 to reduce by other amounts.

Mike

 

[Bob Phillips]

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)