Matheasy
ABS()
Returns the absolute value of a number.
Syntax
fx
=ABS(value)
Try it
F2
→
3,700
Sample data · sales.csv
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Company | Region | Quarter | Revenue |
| 2 | Acme Co | West | Q1 | 18,400 |
| 3 | Acme Co | West | Q2 | 22,100 |
| 4 | Acme Co | West | Q3 | 31,700 |
| 5 | Acme Co | West | Q4 | 48,200 |
| 6 | Globex | East | Q1 | 14,200 |
| 7 | Globex | East | Q2 | 19,800 |
| 8 | Globex | East | Q3 | 23,400 |
Common pitfalls
- An empty cell reference coerces to
0; a literal empty string""returns#VALUE!. All other text inputs also return#VALUE!. - Older Sheets required
ARRAYFORMULAto apply ABS over a range; modern Sheets auto-spills=ABS(A1:A10)for free.