Excel Formula

P

Pravin Chalise

Yrly IncomeTax (15%)Tax (15%) Net Yearly
204000 30600 Tax Payeer ?
72000 10800 Non Tax Payeer ?
3400 510 Non Tax Payeer ?
176000 26400 Tax Payeer ?
162000 24300 Tax Payeer ?

Q.is if yrly income is >150000 add 25%, if it is more than 200000 add 30%
and if yearly income is less than 149000 do not add tax. Solve the problem.
Thanks...
Pravin
 
J

Jacob Skaria

=IF(A2<=150000,0,IF(A2<=200000,A2*0.25,A2*0.3))

If this post helps click Yes
 
Top