ExcelBanter - Excel Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Formula (https://www.excelbanter.com/excel-discussion-misc-queries/230207-excel-formula.html)

Pravin Chalise

Excel Formula

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

Jacob Skaria

Excel Formula

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

If this post helps click Yes
---------------
Jacob Skaria

"Pravin Chalise" wrote:

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

All times are GMT +1. The time now is 08:45 PM.