calculate percentage??

[Learn]

Hello!

I am trying to create a simple formula which would compute a
discounted price on a product. If I choose to calculate the discounted
unit price based on a percentage then I need it to compute the new
price. However, if I have a flat discounted rate, then I need it to
compute the percentage of discount based on the original unit price.
Make sense? Please help.

Thank you

 

[Sheeloo]

With Original Price in A1 and discount percentage in B1
enter this in D1 to get Discounted Price
=A1*(1-B1)
With Original Price in A2 and Discount Amount in C1 this will give you the
Percentage Discount in D1
=B2/A2*100

 

[Fred Smith]

Try this:

a1: original price
a2: discount%
discounted price =a1-a1*a2

a3=flat discounted rate
discount percentage =(a1-a3)/a1

Regards,
Fred.