Strip the sign, keep the size. ABS is one line — but the distance idiom, the SIGN complement and the SQRT rescue are where real sheets get it wrong. All measured here.
Returns the non-negative magnitude. ABS(x) ≥ 0 always; -ABS(x) ≤ 0 always.
ABS removes direction; SIGN reports it; -ABS forces it negative. Seven measured rows show which tool fits which job.
| Expression | Result | Why |
|---|---|---|
| =ABS(-5) | 5 | ABS: magnitude only, direction discarded |
| =SIGN(-5) | -1 | SIGN: direction only, magnitude discarded |
| =SIGN(5) | 1 | SIGN of a positive |
| =SIGN(0) | 0 | SIGN of zero is zero |
| =-ABS(5) | -5 | Force-negative idiom: always ≤ 0 |
| =ABS(5-9) | 4 | Distance between two values |
| =SQRT(ABS(-5)) | 2.2360679775 | ABS before SQRT avoids #NUM! |
All presets are exact and engine-stable. Edit the grid values and every gallery row recomputes live.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
ABS is universal across every Excel version and Google Sheets; complex magnitudes need IMABS instead.
| Platform | Support | Notes | Gotcha |
|---|
ABS is one piece. The full course walks the toolkit end to end with live, measured examples.