Calculate Indian Income Tax on Salary and Casual Income in Excel
Question details
Calculate tax on casual income and salary income in one spreadsheet formula.

- 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.
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.
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.
In Excel, enter the taxable casual-income amount in cell B2.
Enter the taxable salary amount in cell B3.
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.
For a test, enter 100000 in B2 and 600000 in B3. Cell B5 should show 62500 before any additional tax adjustments.

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. Open a spreadsheet: Open WPS Spreadsheet and create a blank workbook or open an existing Excel file.
- 2. Enter income amounts: Enter taxable casual income in B2 and taxable salary income in B3.
- 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. Save the workbook: Choose File > Save As and select an Excel workbook format if you need to share the file with Excel users.

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.




