ABS converts negative numbers to positive numbers.

Positive numbers and zero (0) are unaffected.

The ABS function takes just oneargument,number, which must be a numeric value.

Excel formula: Rank with ordinal suffix

Ifnumberis not numeric, ABS returns a #VALUE!

However, when A1 is greater than B1, the result will be negative.

Square root of negative number

TheSQRT functioncalculates the square root of a number.

Excel formula: Square root of number

If you give SQRT a negative number, it will return a #NUM!

Excel formula: Calculate percent variance

Excel formula: Count or sum variance

Excel formula: Filter values within tolerance

Excel formula: Value is within tolerance

Excel formula: Change negative numbers to positive

Excel formula: Difference is within specific percentage

Excel formula: Find closest match

Excel formula: Count values out of tolerance

Excel formula: Convert inches to feet and inches

Excel formula: Round a number to n significant digits

Excel formula: Lookup number plus or minus N