Excel - Microsoft Excel ABS Function

Description

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

The syntax of the function is : 

ABS( number ) 

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. 

Abs Function Error

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

Common Error