Having trouble with the IF Function.

**nikkismella1** · 08-26-2011, 12:13 AM

I'm trying to help my daughter out with her homework but I'm afraid I have no idea what I'm doing, my experience with Excel is fairly limited. Anyone care to help me out?

The problem is:

Insert and IF statement in cell F4 that inserts 10% if E4 is greater than 99999 and insert 7% if E4 is greater than 49999 and inserts 5% if E4 is greater than 24999 and inserts 0% if E4 is greater than 0.

That just looks like gibberish to me. Please help.

**Azam Ali** · 08-26-2011, 12:52 AM

Try

=if(e4>99999,10%,if(e4>49999,7%,if(e4>24999,5%,0)))

**abousetta** · 08-26-2011, 01:47 AM

Hello and welcome to the forum,

If you need a lot of nested IF statements, then I prefer to us LOOKUP instead. In the example you provided the formula would be:

=LOOKUP(E4,{0,24999,49999,99999},{0,0.05,0.097,0.1})

And the results would be:

0.0%	24998
5.0%	25000
9.7%	50000
10.0%	100000

remember to format as percentage and identify the number of decimal places you want. In this case, one decimal place should suffice.

Hope this helps.

Good luck.

abousetta

**nikkismella1** · 08-26-2011, 03:33 AM

Originally Posted by Azam Ali

Try

=if(e4>99999,10%,if(e4>49999,7%,if(e4>24999,5%,0)))

Thanks a million. Never thought I'd feel like an idiot looking over my daughters homework.

**arthurbr** · 08-26-2011, 03:37 AM

FYI, indicating " nowhere" as location will not help the day you have ^problems involving Regional Settings

**Azam Ali** · 08-26-2011, 05:12 AM

welcome

If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.