Nested "IF" issues!

robatctel

New Member
Joined
Jan 3, 2005
Messages
39
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
Joined
May 9, 2003
Messages
363
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%","-")))
 

Forum statistics

Threads
1,085,429
Messages
5,383,629
Members
401,843
Latest member
stevensmith1

Some videos you may like

This Week's Hot Topics

Top