# ABS

ABS(number)

Returns the absolute value or a number without its sign.

 number The number you want the absolute value of.

 REMARKS
 * The absolute value of a number is just the number without its sign.* The absolute value of a number is also called its modulus.* The "number" can be a cell reference or a named range.* If "number" is negative, this function simply removes the sign, returning a positive number.* If "number" is not numeric, then #VALUE! is returned. Example 12.* The equivalent VBA function is VBA.ABS* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =ABS(B1) = 10 10 2 =ABS(B2) = 10 -10 3 =ABS(B2-B1) = 20 4 =ABS(-2.4) = 2.4 5 =ABS(2.4) = 2.4 6 =ABS(B2)-5 = 5 7 =ABS(-0.036) = 0.036 8 =SQRT(ABS(-16)) = 4 9 =SQRT(ABS(16)) = 4 10 =ABS(TRUE()) = 1 11 =ABS(FALSE()) = 0 12 =ABS("some text") = #VALUE!

 1 - What is the absolute value of the number 10.2 - What is the absolute value of the number -10.3 - What is the absolute value of the result from a formula.4 - What is the absolute value of -2.4.5 - What is the absolute value of 2.4.6 - What is the result of the absolute value of -10 minus 5.7 - What is the absolute value of -0.036.8 - What is the absolute value of the absolute value of -16.9 - What is the square root of the absolute value of 16.10 - What is the absolute value of the logical value True.11 - What is the absolute value of the logical value False.12 - What is the absolute value of some text.