Abs

Returns a value of the same type that is passed to it specifying the absolute value of a number.

Syntax: Abs( number )

number: required Any valid numeric expression. If number contains Null, Null is returned; if it is an uninitialized variable, zero is returned.

The absolute value of a number is its unsigned magnitude. For example, Abs(-1) and Abs(1) both return 1.

Common Errors

Error	When
6 (`&H6`), Overflow	number is a Currency of -922,337,203,685,477.5808 number is an Integer of -32,768 or a Long of -2,147,483,648

This example uses the Abs function to compute the absolute value of a number.

Dim MyNumber
MyNumber = Abs(50.3)    ' Returns 50.3.
MyNumber = Abs(-50.3)    ' Returns 50.3.