User Tools

Site Tools


syntax:functions:abs

Abs(number)

Category: Number function


Description

This function returns the absolute value of number which is the distance of a number on the number line, from 0, without considering which direction the number lies

The absolute value of a number is never negative.


Arguments

ArgumentTypeDescription
numberNumberThe value from which the unsigned absolute value is determined.


Return value type: Number


Remarks

Unlike some other functions which implicitly convert date values to date serial values before evaluating, passing a date value into this function will result in an error ("#The argument must be a number.").


Examples

abs(10) = 10
abs(-5) = 5
abs(40.5) = 40.5
abs(0) = 0
abs(10*100) = 1000  //Passing in a calculation is supported.
abs({MyNum}*[MyVal]) = 15  //{MyNum}=5, [MyVal]=3; parameters are supported.
abs(#2021-10-21) = #The argument must be a number.
syntax/functions/abs.txt · Last modified: 2021/07/31 21:11 by craigt