Method 2 – Income Tax Calculation with SUMPRODUCT Function in Excel Steps: Select cell D14. Type the formula: =SUMPRODUCT($D$7:$D$11-$D$6:$D$10,C14-$B$7:$B$11,N(C14>$B$7:$B$11)) Press Enter. Use AutoFill to fill the rest of the series. How Does the Formula Work? N(...
Read More:Reverse Tax Calculation Formula in Excel Example 2 – Different Tax Brackets and Tax Surcharge Now let’s calculate the tax on salary when where there are different tax brackets (also called slabs) for different income ranges, and a surcharge is applied on the tax for some income r...