1. Calculation functions
  2. All Functions
  3. Numeric functions
  4. ABS

The ABS function returns the absolute value of a number. The absolute value of zero or a positive number remains the same. The absolute value of a negative number is the same number without the negative sign (the positive version).

ABS(Number)

Arguments

ArgumentData typeDescription
NumberNumberThe number to return the absolute value of.

The ABS function returns a number.

Excel equivalent

ABS

Examples

FormulaResult
ABS(-20)20
ABS(20)20
ABS(0)0