OUR DISCOUNTS CHANGE AS ORDER GETS BIGGER

[ELEPHANT-AU]

I'm trying to get a field which will allow a calculation of a differential discount. So our progressive client discount goes from 10% off to 50% off depending on how much the client purchases of particular stock lines.
I can calculate a simple 20% discount (IF(AND(F9>=200,F9<=299.99),F9*0.8) but I need the field to have the variable discount as clients are confused if they see too many prices.
I have tried =SUMIF(IF(AND(F9>=200,F9<=299.99),F9*0.8)),(IF(AND(F9>=300,F9<=399.99),F9*0.7)),(IF(AND(F9>=400,F9<=499.99),F9*0.6)) but it doesn't work.

Suggestions please.

 

[AlanSidman]

See attached example as to how to do this.

 

[Hui]

Elephant

Firstly, Welcome to the Chandoo.org Forums

Please note that it has been detected that this post is Cross-Posted on other Excel Forums

This is considered poor practice when you haven't notified us of the fact.

This is because you may well have received an answer somewhere and yet people here are still trying to solve the problem, where they could be assisting others.

Please ensure that you read the sites rules at:
http://forum.chandoo.org/link-forums/new-users-please-read.17/

Further breaches may result in you loosing access to the site