ABS function

The ABS function take a negative number, like -5, and returns it  as a positive. It’s purpose is to find the absolute value of a number.

= ABS(cell address or a negative number)

ABS Calc image

The C9 cell contains the ABS formula. It returns the number -5 in C8 as a positive. The formula also is available in Microsoft Excel