Nested if statement!

[darrenciccone]

Thank you in advance for all your help!

I am looking for the correct setup of a nested if statement with 4-5 arguments

if sales reach a certain thershold 1% bounus

if sales increase 5% - 10% = 2% bonus

if sales increase 11%-15% = 3% bonus

and if sales increase 15% = 4% bonus

Thanks again for all the help!

 

[Mike Blackman]

Hi,

How about something like;

=A2*LOOKUP(A2,{10000,20000,30000,40000,50000;1,5,11,15,20})

Change the Bold part to match your buckets.

 

[Arvind1977]

=IF(A2>B2,A2,IF(B2>(A2*5%+A2),"2%"))


i think u need this

 

[darrenciccone]

Ok, thanks let me give it a try!