Tax Formula Help Needed

Microsoft Ms sla excel lic/sa 2yr-1
December 10, 2009 at 00:58:27
Specs: Windows XP
our salary is like below
if the salay is $1000
$100 has no tax
from $100-250 the tax is 2%
from $250-1000 tax is 10%
so which formula will help to count the tax?

See More: Tax Formula Help Needed

Report •


#1
December 10, 2009 at 08:43:09
Try this:

=IF(A1<=100,0,IF(AND( A1>100,A1<=250),(A1-100)*0.02,IF(AND(A1>250,A1<=1000),(A1-250)*0.1+3)))

Structure:

If A1 <= 100, return 0
If A1 > 100 and <= 250, then find 2% of the amount above 100.
If A1 > 250 and <= 1000, find 10% of the amount above 250 and add it to 2% of 150 (3).

You don't say what the tax rate is for values above 1000, so the formula, as currently written, will return FALSE for values above 1000.


Report •

#2
December 11, 2009 at 19:56:04
our salary is like below
if the salay is $1000
$100 has no tax
from $100-250 the tax is 2%
from $250-2000 tax is 10%
FROM $2000-5000 tax is 20%

so which formula will help to count the tax?

Sorry dude it was a mistak....
Plz help me on this formul.....


Report •

Related Solutions


Ask Question