# Solved: If Formula if commission how to use

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

Not open for further replies.

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
Regards
Hitesh

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

3. ### etafModerator

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%

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

Regards
Hitesh

As Seen On