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: 906 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
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER

Anupam Parashar & Co.

Ghaziabad

CA Final

View Details
Company
ARTICLESHIP 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
ARTICLESHIP 07 September 2026
CA Articles

Kothari Jain Patil & Chartered Accountants

Pune

CA Inter

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details