Say A1 contains the original (flat unit price)
B1 will contain the discount factor
C1 will contain the purchase amount

In D1, enter:

=A1*(1.-B1)*C1

So if you set B1 to 10%, you will get a 10% discount.
If you set B1 to 0, you get no discount.
--
Gary''s Student - gsnu2007L


"Learn" wrote:

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