Author: Oscar Cronquist Article last updated on March 27, 2018

Converts negative numbers to positive numbers, in other words, the ABS function removes the sign.

Excel Function Syntax



number The number you want to remove the sign from.


The ABS function returns #VALUE if you use a text string, however, it returns 1 for boolean value TRUE and 0 (zero) for FALSE.