Help me out writing a critical formula !

[Mughrabi]

Hello,

I have a small office and i need help writing a formula that would help me calculating the income tax.
The income tax is 0% if your monthly salary is between 0-1000
The income tax is 7% if your monthly salary is between 1000-2000
The income tax is 14% if your monthly salary is over 2000

As an example : if someone's salary is 1400 , the first 1000 has 0% tax , but the 400 has 7%
another one , if someone's salary is 2100 , the first 1000 has 0% tax , 7% for 1000 , and 14% for 100

I wish that anyone can help me to write a formula to solve this !!

Thank you so so much guys

Best Regards,
Mughrabi

---------- Post added at 05:50 AM ---------- Previous post was at 05:49 AM ----------

Forgot to mention that i am using Excel 2007

[Richard Buttrey]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Andrew-R]

Post removed until OP complies with title change.

Sorry, I was busy replying when the request came in.