Back to Top

Login | Register

Please Wait ..

Forum Home > Information Technology > Excel Add - In for Income Tax calculation

Recent Topics

Post New Topic

26 April 2014, 13:24   Report Abuse

Vaibhav Joshi

(F)CA, MBA aspirant

[ Scorecard : 1413]


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.


Syntex is itax( Income , Age)


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


Refer example file for your reference.


Attached File : downloaded 384 times

26 April 2014, 13:46  

Vaibhav Joshi

(F)CA, MBA aspirant

[ Scorecard : 1413]


To install an Excel 2007 add-in, click on the Office Button, the big round decoration in the top left of the Excel window.



This opens the Office Menu. Click the Excel Options button at the bottom of this menu.




The Excel Options dialog opens up. Click the Add-Ins item in the list along the left edge of the dialog to see the Add-Ins panel.



Make sure the Manage dropdown at the bottom shows Excel Add-Ins, then press the Go button. Finally this brings up the familiar Add-Ins dialog.


Message thanked : 1 times

29 September 2014, 14:45  

Vaibhav Joshi

(F)CA, MBA aspirant

[ Scorecard : 1413]

Please downlaod revised Add-in after budget changes!



Attached File : downloaded 361 times

Related Topics / Similar Threads


Post your reply for : Excel Add In for Income Tax calculation

Your are not logged in . Please login to post replies
Click here to login

Not a member yet ?? Click here to signup


Subscribe to the latest topics :

to your account


Remember Me

Forgot your password?

Sign-up now

Join and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.