what is the formula to calculate income tax in excel?
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).