Results 1 to 12 of 12

Nested IF formula for sliding commission scale

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    VA
    MS-Off Ver
    Excel
    Posts
    8

    Nested IF formula for sliding commission scale

    I am trying to create a sliding commission scale where the following occurs:

    The formula will be in Cell E45 and need to return a value of "0", "6%", "8%", "10%" based on Gross profit Percentage.
    Gross profit is cell I50

    Example if Gross Profit is less than 50%, then 0 commission.
    If Gross Profit is 50-60%, then 6% commission
    If Gross Profit is 60-70% then 8% commission
    If Gross Profit is 70% and greater then 10% commission.

    I have come up with the below formula but unable to get that last statement to work once a gross profit of 70% or more is reached.

    =IF(I50<50%,"0",IF(I50<=60%,"6%",IF(I50>=60%-69%,"8%",IF(I50>=70%,"10%"))))

    Does anyone have an suggestions on the correct formula?
    Last edited by tmva; 01-02-2018 at 03:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sliding Scale Commission Structure
    By snakesbee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-29-2016, 05:53 PM
  2. Creating a Sliding Scale Commission Formula
    By Nick1966 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2015, 11:03 AM
  3. Need help in creating a sliding scale commission worksheet
    By Estimated Profit in forum Excel General
    Replies: 7
    Last Post: 02-27-2015, 10:01 AM
  4. Sliding Scale Commission
    By rushbrooksharoon in forum Excel General
    Replies: 10
    Last Post: 06-25-2013, 09:07 AM
  5. [SOLVED] Formula to calculate commission based on sliding scale
    By Excel Dumbo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2013, 10:52 PM
  6. Percentage Commission on a sliding scale.
    By JonPFP in forum Excel General
    Replies: 6
    Last Post: 04-13-2006, 01:30 PM
  7. calculating commission on sliding scale
    By corrado444 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-09-2005, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1