Abs Function

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


Abs( number )

The required numberargument 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.


Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

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.
Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!