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)

“number” can be a cell reference, a function or a formula that returns a number of which you want the absolute value.

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)

variable absnumber will now contain the value 155.3

Joseph Harris
ExcelYogi.com

Related posts:

1. F4 Function Key in Excel To quickly ad the $ symbol around your cell references...
2. Excel CELL () Function The CELL function can be used to find out information...