Income Tax calculation in one go

[Excel VBA Lab]

Hi All,

For finance professional or tax consultant Is it not tedious task to get Income tax payable when you know net taxable income, how easy it would be if through one & simple formula you get tax amount instantly.

Download attached excel file & install / add it as add-ins to your excel.   

You can calculate Income tax for Individual using following user defined function.   

Syntax is =itax( Income , Age)   e.g. =itax(600000,23)

Select any cell in excel and type =itax(income, age)   

Download zip file for example & instruction to install add ins.

Cheers!!

[Ashish Kumar]

It's Superb......!

Thanks a lot for sharing this amazing stuff with us.

Regards

Ashish Kumar