ABS Function in Excel – Get the absolute value in Excel

Absolute Function in Excel

ABS function in Excel returns the absolute value (modulus) of a number. Negative numbers are converted to positive numbers, and positive numbers remain unaffected.

Syntax of ABS Function in Excel

ABS (number)

 number – The number to which the absolute or modulus value needs to be found

Example of ABS Function in Excel

Formula

ABS Function in Excel 1

Result

ABS Function in Excel 2

Note: #VALUE! Error occurs if the supplied number argument is non-numeric.

previous-small ABS Function in Excel                                                                                                                next_small ABS Function in Excel