Microsoft Ms sla excel lic/sa 2yr-1

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?

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.

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.....

Ask Your Question

Weekly Poll

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History