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