ABS Function in Excel, Return Absolute Value of a number

By | April 22, 2019

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

ABS Function in Microsoft Excel-ExcelBlackBook.com