• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

if and functions to compute Professional Tax

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
 

Attachments

  • IF AND Statement.xlsx
    10.6 KB · Views: 5
Back
Top