• 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


  • 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


Thanks for all your help