Solved How To Make Tax Calculator In Excel

May 3, 2015 at 11:50:11
Specs: Macintosh
I'm trying to build a calculator that will break down a calculation.

So, say the value was 1000. I want to use one table, below, to determine the percentage

0- 200 = 0%
201 -500 = 10%
501-1000 = 20%
1001 -5000 = 30%

I want it to break down the 1000 into the thresholds so:

200 @ 0%
500 @ 10%
300 @ 20%.

hope that makes sense. I've tried using the IF formula but i don't understand what i'm doing.

Thanks

C


See More: How To Make Tax Calculator In Excel

Report •

#1
May 3, 2015 at 12:13:48
✔ Best Answer
Try this:

The syntax of an IF() function is:

IF(logical_test, [value_if_true], [value_if_false])

You can nest one IF() function within another,
see if you can follow the logic.

using these numbers:

   0 - 200 = 0%
 201 - 500 = 10%
 501 - 1000 = 20%
1001 - 5000 = 30%

With your value in cell A1
enter the formula in cell B1

=IF(A1<=200,A1,IF(A1<=500,A1+A1*10%,IF(A1<=1000,A1+A1*20%,IF(A1<=5000,A1+A1*30%,""))))

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question