FormulaCraft

How to calculate take-home pay in Excel and Google Sheets

Topic:Finance basics
Excel & Google Sheets
=A2-B2-C2-D2
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Gross PayTaxSocial SecurityOther DeductionsTake-Home
4000800240200
60001200360300
3500700210150
80001600480400

=A2-B2-C2-D2→2760

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

Step by step

  1. 1Column A = Gross Salary, Column B = Income Tax, Column C = Social Security / NI / CPF, Column D = Other Deductions (pension, health insurance).
  2. 2In E2 enter =A2-B2-C2-D2 for take-home pay.
  3. 3Calculate each deduction in its own cell using percentage formulas (e.g., B2=A2*0.20 for 20% tax).
  4. 4Use SUM for multiple deduction columns: =A2-SUM(B2:D2).

Tips

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

Frequently asked

How do I handle pre-tax deductions like pension contributions?

Subtract pre-tax deductions from gross before calculating income tax: TaxableIncome = GrossPay - PensionContribution, then apply tax to that reduced figure.

Can I model different salary levels at once?

Yes — use a data table (Excel: Data > What-If Analysis > Data Table) to show take-home pay across a range of gross salaries simultaneously.

More on Finance basics

See all →
How-to

How to calculate tiered commission

Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.

How-to

How to calculate gross margin

Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.

How-to

How to calculate compound interest

Compute a compounded future value with principal × (1 + rate)^years using POWER. Identical in Excel and Google Sheets.

How-to

How to calculate cost per unit

Divide total cost by total units to find cost per unit using a simple formula in Excel or Google Sheets.

How-to

How to calculate a selling price from a target margin

Use cost and target gross margin percentage to back-calculate the required selling price in Excel or Google Sheets.

How-to

How to calculate simple interest

Multiply principal, rate, and time to compute simple interest using a straightforward formula in Excel or Sheets.

Formulas used

SUMIFROUND / ROUNDUP / ROUNDDOWNSUBTOTALSQRTTAKEVSTACKPROPER

Related tasks

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: