ABS(number)

Returns the absolute value or a number without its sign.

numberThe 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 ABS
* For the Microsoft documentation refer to support.office.com

 AB
1=ABS(B1) = 1010
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.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top