@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
26 April 2014Hi
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.
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 26 April 2014
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.
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 06 September 2014
Hi
PFA after Budger 2014 changes..
Thanks!
Excel Mastery Program
CAclubindia
