ABS Function

User Rating:  / 0

ABS can be used to display the absolute value of a number. The absolute value of a number is the number without its sign.

The format for ABS is: =ABS(number)where "number” can be a cell reference, a function or a formula that returns a number of which you want the absolute value.

For example: cell A1 contains -5

=ABS(A1) Result is 5
=ABS(-5) Result is 5
=ABS(5) Result is 5

ABS can also be used in VBA code:

Dim absNumber As Double
absNumber = Abs (-155.3)

Now the variable absnumber will now contain the value 155.3