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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | ABS(number) |
| Google Sheets | ✔ Built in | ABS(value) |
| Airtable | ✔ Built in | ABS(value) |
| Notion | ✔ Built in | abs(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 ↗ |
| Airtable | ABS(-42.5) | |
| Notion | abs(-42.5) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | Any real number. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=ABS(-42.5) | 42.5 | ||
=ABS(B2-C2) | Size of the gap | Difference regardless of which value is larger. | |
=ABS(B2-C2)/C2 | Absolute % error | Format 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.