The ‘ABS’ function in Excel will return the absolute value of any input number.
This formula works by returning the delta between the input number and zero. As (10) and 10 are both 10 away from zero, the formula would return 10 against both values. As a result, the ABS function has no effect on positive numbers, whilst negative numbers are converted to positives.
This can be useful when working with large datasets where you want to ensure no negatives have been incorrectly included.
Syntax
=ABS(number)
Arguments
Number – input number which you want to get the absolute value of.
Function category
Returns
The ABS function will return a numeric value.
Comments (No)