FUNCTION ABS, ABSOLUTE VALUE

This function returns the absolute value of a number. in other words a number without sign.

how does it work?

Simply type the function syntax in a cell and give the cell reference of the values.

"=abs(cell_ref)"
for example
in the cell "A2" the value is "-505780" which is negative.
Function ABS will be used as under in the CELL "A3" (or anywhere)
"=ABS(A2)"

The value returns in the cell "A3" (or anywhere the function is applied) will be "505780".