Formula Errors

Calculate Indian Income Tax on Salary and Casual Income in Excel

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

Calculate tax on casual income and salary income in one spreadsheet formula.

Calculate Indian Income Tax on Salary and Casual Income in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to apply a 30% rate to casual income and progressive tax slabs to salary income without requiring a macro.
Observed behavior
The desired result is a combined tax amount based on the specified rate and salary slabs.
Before you start

Confirm that the slab thresholds and casual-income rate apply to the relevant tax year, regime, and income type. This example excludes deductions, rebates, cess, and surcharges; enter nonnegative taxable amounts after any applicable deductions.

Solution 1Recommended

Use SUMPRODUCT to combine casual-income and salary tax

Use this formula to calculate the specified illustrative tax rates without VBA.

The formula applies 30% to casual income and marginal salary rates of 0%, 5%, 20%, and 30% across thresholds of ₹0, ₹250,000, ₹500,000, and ₹1,000,000. These are example rates, not a statement of current tax law.

1
Enter casual income

In Excel, enter the taxable casual-income amount in cell B2.

2
Enter salary income

Enter the taxable salary amount in cell B3.

3
Calculate the tax

Select cell B5, enter =30%*B2+SUMPRODUCT((B3>={0,250000,500000,1000000})*(B3-{0,250000,500000,1000000}),{0,0.05,0.15,0.1}), and press Enter.

4
Check the result

For a test, enter 100000 in B2 and 600000 in B3. Cell B5 should show 62500 before any additional tax adjustments.

Use SUMPRODUCT to combine casual-income and salary tax
Check the applicable rules: Actual Indian income tax depends on the tax year, regime, income category, and applicable deductions, rebates, cess, and surcharges. Adjust the calculation only after confirming the relevant rules.
Calculate tax without a macro

Calculate the same tax example in WPS Spreadsheet

Use the SUMPRODUCT formula in WPS Spreadsheet to combine the example casual-income rate and salary slabs without creating a VBA function.

  1. 1. Open a spreadsheet: Open WPS Spreadsheet and create a blank workbook or open an existing Excel file.
  2. 2. Enter income amounts: Enter taxable casual income in B2 and taxable salary income in B3.
  3. 3. Enter the formula: Select B5 and enter =30%*B2+SUMPRODUCT((B3>={0,250000,500000,1000000})*(B3-{0,250000,500000,1000000}),{0,0.05,0.15,0.1}), then press Enter.
  4. 4. Save the workbook: Choose File > Save As and select an Excel workbook format if you need to share the file with Excel users.
Calculate the illustrated salary slabs and casual-income tax in one cell.Open and save Microsoft Excel XLSX files.Use a familiar spreadsheet interface without writing a macro.Work with a free, easy-to-use office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Do I need VBA to calculate the tax?

No. Enter the SUMPRODUCT formula in B5 to calculate the example tax from the amounts in B2 and B3 without a macro.

What salary rates does the formula use?

It uses marginal rates of 0% up to ₹250,000, 5% from ₹250,000 to ₹500,000, 20% from ₹500,000 to ₹1,000,000, and 30% above ₹1,000,000.

Does the formula include cess or a tax rebate?

No. The result in B5 excludes cess, surcharges, rebates, and other adjustments. Check the rules for the applicable tax year and regime before using it for a tax return.

Will the 30% rate apply to every kind of casual income?

Not necessarily. The formula applies 30% to all of B2 as an example. Check the rules for the specific income category and tax year before relying on that rate.