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]


Hi

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 : 20_20_itax.zip downloaded 363 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!

 

Thanks



Attached File : 6_6_itax_sep2014.zip downloaded 328 times




Related Topics / Similar Threads

More..

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

Message




Subscribe to the latest topics :




Sign-in to your account


Username:
Password:

Remember Me

Forgot your password?

Sign-up now



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