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

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

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 / ROUNDDOWN

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

Last reviewed: