General discussion
August 21, 2006 at 09:50 AM
mamahtm

Help with the IF Function in Excel

by mamahtm . Updated 20 years, 1 month ago

Hi, I am preparing a Tax Calculator using Excel but can’t get the formula right. Here’s an example:

Gross annual income:
Below 1000 should be tax free
1000-2000 should pay 220
2000-3000 should pay 330
……..
above 10,000 should pay 1100 etc, etc

I tried using the IF Function but still received errors. Urgent help is welcomed.

This discussion is locked

All Comments