ABS Function
Returns the absolute value of a number — its size without the sign.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number (zero or positive)
Want to practice ABS in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ABS removes the minus sign: ABS(−250) is 250, ABS(250) stays 250.
It's ideal for variances, where you care how far off you are rather than in which direction.
Syntax
=ABS(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number to make positive. |
Examples
Example 1 — Size of the variance
How far was each region from budget, either way?
D2fx=ABS(C2-B2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Budget | Actual | Off by |
| 2 | West | 600 | 620 | 20 |
| 3 | East | 500 | 480 | 20 |
| 4 | North | 400 | 350 | 50 |
=ABS(C2-B2) Explain
Common mistakes
- Losing direction. Keep a separate column with the signed variance if readers need to know over vs. under.
Notes
- Related functions: SIGN, SUMPRODUCT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.