I'm looking for a practical way to calculate Pakistan salary income tax in Excel.

Yes, keep the tax slabs in a separate table. That makes changes easier to maintain and lets you check the thresholds and rates without digging through a long formula.

On a separate sheet, create a table named TaxSlabs with three columns: LowerBound, BaseTax and Rate. Fill it with the applicable annual salaried-income tax slabs published by Pakistan’s FBR. Include the zero-tax band, sort LowerBound in ascending order, and enter rates as percentages.

With monthly taxable salary in B2, this Excel 365 formula calculates the annual slab tax:

Each lookup finds the matching threshold or the next smaller one. The calculation then adds the base tax to the tax on income above that threshold.

Divide the annual result by 12 for estimated monthly tax. Subtract that and any other deductions from monthly gross salary to estimate take-home pay. Keep gross salary and taxable salary in separate cells if they differ.

Put any applicable surcharge, credits and other adjustments in separate calculations. Multiplying by 12 assumes the salary stays constant, so bonuses or midyear raises need additional handling.

Keep a dated copy of each tax year’s table instead of overwriting previous years. After an update, test income just below, exactly at and just above each threshold.