Related Function:

The ABS function returns the absolute value, the modulus, of a supplied number. The absolute value of a number is the number without its sign.




Argument Description
number The real number of which you want the absolute value. The number argument can be supplied to the function as either a simple number, a reference to a cell containing a number, or as a numeric value returned from another function or formula


  A B C D
1 Data      
2 -2.5       
3 2.5      
4 =(2-3.5)      
6 Function Result Notes
7 =ABS(-10) 10 The absolute value of -10
8 =ABS(A2) 2.5 The absolute value of 2.5
9 =ABS(A3) 2.5 The absolute value of -2.5
10 =ABS(A4) 1.5 The absolute value of -1.5 (2 – 3.5 = -1.5)

Usage note: ABS an also be used in VBA code:

Now the variable absNumber will contain the value 155.3

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied number argument cannot be recognized as numeric value