The Excel ABS Function

Related Function:
SIGN Function

Basic Description

The Excel ABS function returns the absolute value (i.e. the modulus) of any supplied number.

The syntax of the function is:

ABS( number )

where the number argument is the numeric value that you want the modulus of.


Abs Function Examples

The following spreadsheet shows several examples of the Excel Abs function.

 Formulas:
 A
1=ABS( -1 )
2=ABS( -6.5 )
3=ABS( 6.5 )
4=ABS( 0 )
5=ABS( 2 - 4.5 )
 Results:
 A
11
26.5
36.5
40
52.5

Further details and examples of the Excel Abs function are provided on the Microsoft Office website.


Abs Function Error

If you get an error from the Excel Abs function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs if the supplied number argument is non-numeric.