September 13th in Functions by .

Abs function

This tutorial will review the Abs function.

Owner and site operator for Excelbuddy.com

This tutorial will review the Abs function. The Abs function returns the absolute value of a number.

 Wikipedia Definition: In mathematics, the absolute value (or modulus) |a| of a real number a is a’s numerical value without regard to its sign. So, for example, 3 is the absolute value of both 3 and ?3.

 Here an example of the Syntax.

 =ABS(number)    -  number refers to the numeric value in a specific cell

-45 will return 45
-0.235 will return .235
-0.1857 will return .1857
-143,765 will return 143,765

Leave a Reply

Excelbuddy.com Get your excel questions answered in our forum!