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: