ABS

Definition: ABS is a function that returns the absolute value of a number. The absolute value of a number is the number without its sign.

Syntax: =ABS(number)

Situation: This formula is suitable when you need to find the positive value of a negative number or a positive number.

Example: If you have a negative debt of $500 and a positive credit of $200, the total balance can be found using the formula =ABS(-500)+200, which returns a value of $700.