Last modified: December 06, 2011
Applies to: Office 2013 | VBA
Returns a value of the same type that is passed to it specifying the absolute value of a number.
The required number argument can be 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.
This example uses the Abs function to compute the absolute value of a number.
MyNumber = Abs(50.3) ' Returns 50.3.
MyNumber = Abs(-50.3) ' Returns 50.3.