1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: If Formula if commission how to use

Discussion in 'Business Applications' started by hitesh12345, Jan 30, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. hitesh12345

    hitesh12345 Thread Starter

    Joined:
    Jan 30, 2013
    Messages:
    3
    Hi Everyone,
    I am the newest member to this forum.

    I have one query about how to implement if formula in this situation

    I have got eligiblity bracket of
    Criteria Amount 1% - 74% - 75% - 99% 10,000 100% - 124% 12,500 125% & Above 15,000
    So now if a person has achived 70% then how will I implement the If Formuala for the amount which he is eligible
    Thanks In Advance
    Regards
    Hitesh
     
  2. hitesh12345

    hitesh12345 Thread Starter

    Joined:
    Jan 30, 2013
    Messages:
    3
    Criteria Amount 1% - 74% NIL 75% - 99% 10,000 100% - 124% 12,500 125% & Above 15,000
     
  3. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    65,252
    First Name:
    Wayne
    what happens if
    below 1%
    between 74 and 75 %
    between 99 and 100%
    between 124 and 125%

    you can use a nested if , array lookup or vlookup

    nested IF

    =IF(A1>=125,15000,IF(A1>=100,12500,IF(A1>=75,10000,IF(A1>=1,0,"invalid"))))

    or an array formula
    =IFERROR(LOOKUP(A1,{1,75,100,125},{0,10000,12500,15000}),"invalid")

    BUT need to know the fractions of % ie what is 74.5% or 124.5% or 0.5%
     
  4. hitesh12345

    hitesh12345 Thread Starter

    Joined:
    Jan 30, 2013
    Messages:
    3
    Thanks a Lot Mate. Well Appreciated

    Regards
    Hitesh
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1087500

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice