show percentage of order total as a discount

**DHEKOD** · 05-26-2009, 12:35 PM

Hi there,

I have looked around the forums for an answer to this but couldn't find it,

I have an order form, and I want a formula in a cell to show a discount of 3% of the order value, but only if the order reaches a certain amount (say $10,000)

I have tried with the If function, and can do it with amounts, (if i wanted to discount $300 say) but i cannot figure out how to do it with a percentage!

this is the formula i am using to add a $100 handling fee if the order is under $8000 if that helps at all. =IF(AND(E194<8000),100)

any help would be appreciated,

thanks

**JBeaucaire** · 05-26-2009, 12:39 PM

Better Handling Fee formula, no IF needed:

=100*(E194<8000)

Then your discount can be done the same way:

=(E194*3%)*(E194>=10000)

...and welcome to the forum!

**DHEKOD** · 05-26-2009, 12:58 PM

That is great, thanks so much!

Dean

**JBeaucaire** · 05-26-2009, 01:01 PM

Glad to help!
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].

(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)