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. See Example 12.
* The equivalent VBA function is VBA.ABS
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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.