### 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.
* The equivalent VBA function is ABS
* For the Microsoft documentation refer to support.office.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!

#### Expand ...

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.