ABS Function Explained

The ABS() function in Microsoft Excel returns the absolute value of a number. It takes a single argument, which is a number, and returns the positive version of that number, regardless of whether it is positive or negative. For example, ABS(-5) would return 5.

ABS Function Syntax

ABS(number)

  • number: The number for which you want the absolute value.