1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

# OUR DISCOUNTS CHANGE AS ORDER GETS BIGGER

Discussion in 'Ask an Excel Question' started by ELEPHANT-AU, Aug 12, 2017.

1. ### ELEPHANT-AUNew Member

Messages:
1
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.
2. ### AlanSidmanActive Member

Messages:
121
See attached example as to how to do this.

File size:
8.6 KB
Views:
6
3. ### HuiExcel NinjaStaff Member

Messages:
10,532
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