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 |