calculate percentage??

  • Thread starter Thread starter Learn
  • Start date Start date
L

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
 
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
 
Try this:

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

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

Regards,
Fred.
 
Back
Top