Question: how to calculate income tax in excel?
Answer: Add a Differential column right to the tax table. ... 
Add an Amount column right to the new tax table. ... 
Add a Tax column right to the new tax table. ... 
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).