# 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 belowif the salay is \$1000\$100 has no taxfrom \$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

#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 0If 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 belowif the salay is \$1000\$100 has no taxfrom \$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