ABS(x)

The ABS function calculates the absolute value (i.e. it removes the negation sign, if present) of a single number, x. You can also enter x as a single cell address or cell name.

For example:

ABS(31)

returns 31

ABS(-31)

returns 31

ABS(B6)

returns positive value of the cell B6

See also:

Other mathematical functions