ABS

Microsoft Office Spreadsheet Functions

Show All

ABS

See Also

Returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax

ABS(number)

Number  is the real number of which you want the absolute value.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

Data
-4
Formula Description (Result)
=ABS(2) Absolute value of 2 (2)
=ABS(-2) Absolute value of -2 (2)
=ABS(A2) Absolute value of -4 (4)