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

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