Spreadsheet formulas explained, side by side

ABS Function in Excel, Google Sheets, Airtable & Notion

ABS returns a number without its sign: ABS(−42) and ABS(42) are both 42.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inABS(number)
Google Sheets✔ Built inABS(value)
Airtable✔ Built inABS(value)
Notion✔ Built inabs(number)
Try ABS with your own values
Result (as Excel & Google Sheets return it)
42.5
Your formula, ready to paste
Excel=ABS(-42.5) open excel.new ↗
Google Sheets=ABS(-42.5) open sheets.new ↗
AirtableABS(-42.5)
Notionabs(-42.5)

Arguments

ArgumentWhat it means
numberAny real number.

Examples

FormulaResultWhyCopy
=ABS(-42.5)42.5
=ABS(B2-C2)Size of the gapDifference regardless of which value is larger.
=ABS(B2-C2)/C2Absolute % errorFormat as a percentage.

Examples use Excel / Google Sheets syntax unless noted.

How ABS works

ABS is mostly used to measure “how far apart” two values are without caring about direction: budget versus actual, forecast error, distance from a target. =ABS(Actual - Budget) > 100 flags any line that is more than 100 off in either direction.

It works identically in all four apps. Remember it hides direction, so keep a separate column (or use SIGN) if you also need to know whether a value was over or under.

Frequently Asked Questions

How do I make a negative number positive only when it is negative?
That is exactly ABS: positive numbers are returned unchanged.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.