The Excel ABS Function

Search this site: Custom Search

Related Function:  SIGN Function

Basic Description

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

The syntax of the function is :

where the number argument is a numeric value, that 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.

Abs Function Examples

The following spreadsheet shows several examples of the Excel Abs function. The format of the functions are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

Formulas:

Results:

Further information and examples of the Excel Abs function can be found 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 :