Returns the absolute value of a numeric expression. The absolute value is the expression’s unsigned magnitude.
Abs (number)
Number - (Input, expression, Required)
If Null is passed, Null is returned. If a string is passed, it is first converted to numeric form. If non-numeric value is passed, Error is returned.
An unsigned numeric value of the same type passed.
|
Abs (2) |
Returns 2 |
|
Abs (-2) |
Returns 2 |
|
Abs (-2.3) |
Returns 2.3 |
|
Abs (“-2.3”) |
Returns 2.3 |
|
Abs (Null) |
Returns Null |
|
Abs (Error) |
Returns Error |
Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.
Functions | Atn function | Cos function | Exp function | Fix function | Int function | Log function | Max function | Min function | Rnd function | Round function | Sgn function | Sin function | Sqr function | Tan function
© 2004-2021 looksoftware. All rights reserved.