ABS
Returns the absolute value of a number.
Math & TrigonometryMath Basics
What it does
Returns the absolute value of a number (converts negative numbers to positive).
Syntax
ABS(number)
Arguments
number(number) — The real number of which you want the absolute value.
Examples
Calculate variance
Find the absolute difference between Actual and Budget.
FORMULA
=ABS(A2-B2)
RESULT
200
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Actual | Budget |
| 2 | 1000 | 1200 |
| 3 | 1500 | 1300 |