# Nested "IF" issues!

#### robatctel

##### New Member
I need to be able to say in a cell "If the amount in B4 is over 800 dollars the customer gets 10% discount so cell B5 will show 10% or if the amount is over 1000 they get a 15% discount, or if its over 2000 dollars they get a 20% discount" I swear every time I try to get this to work I get an error. Can someone tell me what the formula would be for this? I know I am missing something just can't figure out what I am doing wrong.

I just have a basic spreadsheet that I am trying to help my uncle with and this is driving me nuts! lol

Thanks People! Its been awhile since I have posted to here but you guys/gals are the greatest!

EDIT: I just need the cell to show "10%" not actual show what 10% would be...hope that helps

Last edited:

#### JonRowland

##### Active Member
This formula should do it for you.

=IF(AND(B4>800,B4<=1000),"10%",IF(AND(B4>1000,B4<=2000),"15%",IF(B4>2000,"20%","-")))

#### robatctel

##### New Member
Awesome! Thank you kind sir!

#### bbott

##### Well-known Member
Another option:

=LOOKUP(B4,{0,800,1000,2000},{0,0.1,0.15,0.2})