Income tax excel add-in

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 : 112266 1311609 itax.zip downloaded: 917 times
Replies (3)

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.

Hi

 

PFA after Budger 2014 changes..

 

Thanks!

Thanks Vaibhav for presenting Demo....

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
14 November 2026
Manager - Indirect Tax (GST)

Westbridge Consulting LLP

New Delhi

CA

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details