Abs function

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.

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

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.