ABS Function in Excel, Return Absolute Value of a number

ABS Function in Excel will give absolute value of the number or formula. An Absolute number is a number without its sign. Eg:- Minus Five (-5) Minus is a sign, then the absolute number would be only 5 without minus sign.

ABS Function in Excel

Syntax of ABS function in Excel

ABS(number)


ABS function Example:

Let say there are we want an absolute value for  -10

=ABS(-10) will give 10

Let say there are three values -5,-10 and - 8 in A1, B1 and C1 respectively.

=ABS(A1*B1*C1) will give 400