## \$hide=mobile

Income Tax calculation is difficult Job for normal persons but it is difficult for Professionals persons as it is  difficult to write the lengthy formula again and again.or even if we are adopting copy paste trick the same from some other Excel sheet then also we have to find out the old file and required cell in the file.So I thought there should be excel command in one go to calculate Tax on woman ,sr citizen and for other also.,I have developed a Excel Add-in for 09-10 Fy which will create short cuts to calculate Tax in one command ,no need to copy or type lengthy Formula again and again and Now have extended the same for 10-11Financial year also .

Features of the utility
Now No need to type length formula again and again just type short cuts shown below and formula will be shown in required cell.Further if you forward the sheet to other person then formula will remain the sheet .

1. To calculate tax on resident Woman with command "Ctrl+shift+W" and following formula fill be shown in the selected excel Cell
2. =ROUND(IF(E10>800000,ROUND(E10-800000,-1)*0.3+91000,IF(E10>500000,ROUND(E10-500000,-1)*0.2+31000,IF(E10>190000,ROUND(E10-190000,-1)*0.1,0))),0)
3. To calculate tax on Resident Sr Citizen with command "Ctrl+shift+S" and following formula fill be shown in the selected excel Cell.
4. =ROUND(IF(E11>800000,ROUND(E11-800000,-1)*0.3+86000,IF(E11>500000,ROUND(E11-500000,-1)*0.2+26000,IF(E11>240000,ROUND(E11-240000,-1)*0.1,0))),0)
5. To calculate tax on Male with command "Ctrl+shift+M" and following formula fill be shown in the selected excel Cell.
6. =ROUND(IF(E9>800000,ROUND(E9-800000,-1)*0.3+94000,IF(E9>500000,ROUND(E9-500000,-1)*0.2+34000,IF(E9>160000,ROUND(E9-160000,-1)*0.1,0))),0)
E10 here means cell immediate top cell in same column ,one row above
7. Spell Figures into words in Indian as well as in other styles( excel function)

How to Install

1. Download a Small File of just 40KB(Download short cuts for tax calculation10-11 FY)  ,unzip the file and save it in your hard disk at any place permanently (do not change location there after, otherwise all the formula results for spell will be lost )
2. Now Open any excel file
4. Browse the location ,where you have placed the Downloaded File,select the file(if file is not shown at the location ,then browser window select Type of File "All Files"
5. After selection ,click ok .
6. A new add-in will be shown in Excel Add-ins List named as Taxcal 10-11
7. Thats all ,this is one time process ,no need to do it again and again ,No macro problem ,activate macro or deactivate macro etc.
How it works
1. Install Add-ins first ,as shown above.
2. type your total taxable Income.
3. In Next row under same column ,Type command
1. Ctrl+shift+M for male /other person tax calculation
2. Ctrl+shift+W for woman tax calculation
3. Ctrt +Shift+S for Resident Senior citizen.
4. Tax value will be shown.(in this calculator taxable income has been rounded Off to multiple of  10 and Tax has been R.off in rupees.
5. To use Spell word type" =spell(cell number or any figure)",figure will be converted in to words.suppose you have typed "=spell(100) " then it will be shown as Rupee One hindered Only "
Benefits
• Short Cut for tax calculation for Individual
• Convert Figures Into Word
Hope you will found all things in order ,if not then kindly left your comment below.

BLOGGER
Share the Post with your Friends
Name