If And function

[odoolead1]

Hi,
I am calculating tax based on the range of salary
If the salary is less than or equal to 15000 then tax is 0
if the salary is greater than 15000 and less than or equal to 20000 the tax is 150
if the salary is greater than 20000 the tax is 200

My formula didnt work

=IF(B9<=15000,0),IF(AND(B9>=15001,B9<=20000,150),IF(B9>20000,200))
I attached a sample file.


Thanks
Appreciate all the help.

 

[vletm]

odoolead1
eg =IF(B9>20000,C5,IF(B9>15000,C4,C3))

 

[odoolead1]

odoolead1
eg =IF(B9>20000,C5,IF(B9>15000,C4,C3))

Thank you Sir for solving my issue. Have a great day