Math · magnitude · Nov 2026

ABS.

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.

D1
fx
=ABS(number)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How ABS works

Returns the non-negative magnitude. ABS(x) ≥ 0 always; -ABS(x) ≤ 0 always.

=ABS(number)
numberAny real number or expression. Text raises #VALUE!; errors propagate.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
signs

The sign family — ABS, SIGN and friends

ABS removes direction; SIGN reports it; -ABS forces it negative. Seven measured rows show which tool fits which job.

ExpressionResultWhy
=ABS(-5)5ABS: magnitude only, direction discarded
=SIGN(-5)-1SIGN: direction only, magnitude discarded
=SIGN(5)1SIGN of a positive
=SIGN(0)0SIGN of zero is zero
=-ABS(5)-5Force-negative idiom: always ≤ 0
=ABS(5-9)4Distance between two values
=SQRT(ABS(-5))2.2360679775ABS before SQRT avoids #NUM!
⚠ ABS destroys information: after ABS you can no longer tell whether the input was above or below target. If direction matters (over/under budget, early/late), keep SIGN alongside or use the signed difference.
Use ABS for magnitudes and distances, SIGN for direction flags, and ABS(a-b) for 'how far apart'. Never use ABS to hide a negative you should be investigating.
// 03 — Try it live

Interactive ABS playground

All presets are exact and engine-stable. Edit the grid values and every gallery row recomputes live.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where ABS works

ABS is universal across every Excel version and Google Sheets; complex magnitudes need IMABS instead.

PlatformSupportNotesGotcha
✓ Supported full ABS◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master magnitude

ABS is one piece. The full course walks the toolkit end to end with live, measured examples.

  • Distance is ABS(a-b), not ABS(a)-ABS(b)
  • ABS vs SIGN vs -ABS
  • SQRT(ABS) for safe roots
  • Tolerance checks with ABS
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked