Advisory: Information relates to the law prevailing in the year of publication/ as indicated. Viewers are advised to ascertain the correct position/prevailing law. Income & Tax Calculator by Finotax. Tax Calculator (Non-Individuals) Use this free online Income Tax Calculator for Individuals, Senior Citizens and HUFs for Assessment Years 2019-20, 2020-21, 2018-19 and 2017-18 (Current Year, Next Year and Previous Years) for following calculations.
How to calculate income tax in Excel?
In some regions, the income tax will be taken out from your incomes (salary) by your company accountants, while in some regions it requires to calculate and declare the income tax by yourself. How to figure out your income tax? There are several solutions in Excel.
Easily combine multiple worksheets/workbooks/CSV files into one worksheet/workbook
It may be tedious to combine dozens of sheets from different workbooks into one sheet. But with Kutools for Excel’s Combine (worksheets and workbooks) utility, you can get it done with just several clicks!Full Feature Free Trial 60-day!
Recommended Excel Productivity Tools
Bring tabbed editing and browsing to Office (include Excel), much more powerful than the browser's tabs. Free Download...
More than300 powerful advanced features for Excel, designed for1500 work scenarios, save70% time for you. Free Download...
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Calculate income tax in Excel
Supposing you have got the tax table in the Range A5:C12 as below screenshot shown, and your income is placed in the Cell C1. Now you can calculate your income tax as follows:
1. Add a Differential column right to the tax table. In the Cell D6 type 10%, in the Cell D7 type the formula =C7-C6, and then drag the AutoFill Handle to the whole Differential column. See screenshot:
2. Add an Amount column right to the new tax table. In the Cell E6 type the formula =$C$1-A6 ($C$1 is the cell with your income), and then drag the AutoFill Handle to the whole Amount column. See screenshot:
3. Add a Tax column right to the new tax table. In the Cell F6 type the formula =E6*D6, and then drag the AutoFill Handle until negative results appear. See screenshot:
4. Click into the cell you will place the income tax at, and sum all positive numbers in the Tax column with the formula =SUM(F6:F8). See screenshot:
So far you have figured out the income tax of the specified income already.
Calculate income tax with SUMPRODUCT function in Excel
Actually, you can apply the SUMPRODUCT function to quickly figure out the income tax for a certain income in Excel. Please do as follows.
1. In the tax table, right click the first data row and select Insert from the context menu to add a blank row. See screenshot:
2. Select the cell you will place the calculated result at, enter the formula =SUMPRODUCT(C6:C12-C5:C11,C1-A6:A12,N(C1>A6:A12)), and press the Enter key. See screenshot:
Note: In the above formula, C6:C12-C5:C11 figures out the differential rates, C1 is the specified income, C1-A6:A12 calculates the amount to each differential rate, and you can change them as you need.
Calculate income tax with Vlookup function in Excel
Frequently, you can get the tax table with cumulative tax for each tax bracket. In this condition, you can apply the Vlookup function to calculate the income tax for a certain income in Excel.
Select the cell you will place the calculated result at, enter the formula =VLOOKUP(C1,A5:D12,4,TRUE)+(C1-VLOOKUP(C1,A5:D12,1,TRUE))*VLOOKUP(C1,A5:D12,3,TRUE) into it, and press the Enter key. See screenshot:
Note: In above formula, C1 is the specified income, A5:D12 is the tax table, and you can change them as you need.
Related articles:
Recommended Productivity Tools for Excel
Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd
- More than300 powerful advanced features, designed for1500 work scenarios, increasing productivity by70%, give you more time to take care of family and enjoy life.
- No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
- Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds,
- Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
- 110,000 highly effective people and 300+ world-renowned companies' choice.
- 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.
Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs
- Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.