Solved: If Formula if commission how to use

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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
 

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
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,454
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%
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Members online

Top