Multiple 'if' statements

[jdinker]

I am working on saving myself some troubles when doing commissions in excel. What I am trying to do is when a employee sells less than $600 their commision will be 0 when it is between 600 and 1000 then it is 10% and anything above $1,000 is 15%.

The equation I have right now is:
=IF(G6<=599.99, G6*0,IF(G6>=600,G6*0.1,IF(G6>=1000,G6*0.15)))

The first two parts seem to be working (the 0 and the 10%) but the 15% will not take. When I say it will not take I mean it continues to multiply by 10% not 15%

Any idea what I'm doing wrong?

Thanks in advance,
Josh

[MarvinP]

Try
=IF(G6<=599.99, G6*0,IF(G6<=1000,G6*0.1,G6*.15))

[Haseeb Avarakkan]

try this,

=G6*LOOKUP(G6,{-9E300,600,1000;0,0.1,0.15})

If you want to get Amount + it's %, use

=G6*LOOKUP(G6,{-9E300,600,1000;0,1.1,1.15})

[jdinker]

Marvin you did it! I was stuck trying to make a third 'if' but I see how this should work now.

Thank you much for you help!