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

Use the ABS function to find the absolute value of a number.

The absolute value of a non-negative number (a positive number, or zero), is the same number. For example, the absolute value of 4 is 4.

If a number is negative, its absolute value is the same number, without the negative sign. For example, the absolute value of -3 is 3.

Syntax

ABS(number)

The ABS function has the following arguments.

Argument Data type Description
number (required)

Number

The number you want to find the absolute value of.

Constraints

This function has no constraints.

Examples

The following table shows some example formulas using the ABS function.

You can enter values directly into your formula, or reference line items or list properties.

Formula Description Result
ABS(Product.Stock) This example shows how you can include line items or list properties in your formula. In this example, the value of Product.Stock is 3.

3

ABS(-20)

The absolute value of -20.

20

ABS(-412.3912)

The absolute value of -412.3912.

412.3912

Excel equivalent

ABS