Features of the utility
- To calculate tax on resident Woman with command "Ctrl+shift+W" and following formula fill be shown in the selected excel Cell
- To calculate tax on Resident Sr Citizen with command "Ctrl+shift+S" and following formula fill be shown in the selected excel Cell.
- To calculate tax on Male with command "Ctrl+shift+M" and following formula fill be shown in the selected excel Cell.
- Spell Figures into words in Indian as well as in other styles( excel function)
E10 here means cell immediate top cell in same column ,one row above
How to Install
- Download a Small File of just 40KB(Download short cuts for tax calculation 09-10 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 )
- Now Open any excel file
- Go to tools >Add-ins>Browse
- 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"
- After selection ,click ok .
- A new add-in will be shown in Excel Add-ins List named as Taxcal0910
- Thats all ,this is one time process ,no need to do it again and again ,No macro problem ,activate macro or deactivate macro etc.
- Install Add-ins first ,as shown above.
- type your total taxable Income.
- In Next row under same column ,Type command
- Ctrl+shift+M for male /other person tax calculation
- Ctrl+shift+W for woman tax calculation
- Ctrt +Shift+S for Resident Senior citizen.
- 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.
- 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 "
- Short Cut for tax calculation for Individual
- Convert Figures Into Word
Read more: INCOME TAX CALCULATION FY 10-11 EXCEL ADD IN PLUS SPELL FIGURE ADDIN | SIMPLE TAX INDIA-TDS RATE INCOME TAX RATE