Calc ABS function

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Help CentreFunctions & Formulas

For a full list of available calculation functions, please read What calculation functions are supported.

This article describes the formula syntax and usage of the ABS function.


Description

Returns the absolute value of a number. The absolute value of a number is the number without its sign.


Syntax

ABS(number)

The ABS function syntax has the following arguments:

  • number - Required. The real number of which you want the absolute value.

Example

FormulaDescriptionResult
=ABS(2)Absolute value of 22
=ABS(-2)Absolute value of -22
=ABS({variable})Absolute value of -4 (assuming the value of the {variable} variable is -44

Errors

For a full list of formula errors, please read Formula errors.


Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.