2. Calculation functions
  3. All functions
  4. Numeric functions
  5. 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

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.