# 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

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

Regards
Hitesh

#### hitesh12345

Criteria Amount 1% - 74% NIL 75% - 99% 10,000 100% - 124% 12,500 125% & Above 15,000

#### etaf

Wayne
Moderator
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%

#### hitesh12345

Thanks a Lot Mate. Well Appreciated

Regards
Hitesh

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.

As Seen On