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-AU

    ELEPHANT-AU New 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. AlanSidman

    AlanSidman Active Member

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

    Attached Files:

  3. Hui

    Hui Excel Ninja Staff 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

Share This Page