excelnovice2000
Member
Hello Gurus,
Can I get some help in solving excel problem using if and function. I have attached a sample file
3 Conditions:
If amount is less than 15000 value is 0
If amount is >= 15000 and <= 20000 value is 150
If amount is > 20001 value is 200
I tried the below formula, but I am getting FALSE values
IF(A3<15000,0,IF(AND(A3>=15001,A3<=20000,150),IF(A3>20000,200)))
Thanks for all your help
Can I get some help in solving excel problem using if and function. I have attached a sample file
3 Conditions:
If amount is less than 15000 value is 0
If amount is >= 15000 and <= 20000 value is 150
If amount is > 20001 value is 200
I tried the below formula, but I am getting FALSE values
IF(A3<15000,0,IF(AND(A3>=15001,A3<=20000,150),IF(A3>20000,200)))
Thanks for all your help
Attachments

10.6 KB Views: 4