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

ArgumentRequired?What it does
numberYesThe number to make positive.

Examples

Example 1 — Size of the variance

How far was each region from budget, either way?

D2fx=ABS(C2-B2)
ABCD
1RegionBudgetActualOff by
2West60062020
3East50048020
4North40035050
=ABS(C2-B2) Explain

Example 2 — Within tolerance?

Flag variances bigger than 5% of budget.

=ABS(C2-B2)/B2>5% Explain

Common mistakes

  • Losing direction. Keep a separate column with the signed variance if readers need to know over vs. under.

Notes

Kyle Stott

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.