banner_ad

Income tax excel add-in

Excel for Finance 3557 views 3 replies

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: 894 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....


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 08 June 2026
Internal & Taxation Article

O P Bagla & Co LLP

New Delhi

CA Inter

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details