syntax:functions:abs
This is an old revision of the document!
Table of Contents
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
Argument | Type | Description |
---|---|---|
number | Number | The value from which the 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.1627440623.txt.gz · Last modified: 2021/07/27 22:50 by craigt