ABS(number)

Returns the absolute value or a number without its sign.


numberThe number you want the absolute value of.

* 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.
* 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.


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top