SIGN

SIGN(number)

Returns the numerical value indicating if a number is positive, negative or zero.

number

The number you want the sign of.

REMARKS

* If "number" > 0, then 1 is returned.
* If "number" = 0, then 0 is returned.
* If "number" < 0, then -1 is returned.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the ABS function to return the absolute value or a number without its sign.
* The equivalent VBA function is VBA.SGN
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=SIGN(100) = 1
2	=SIGN(4) = 1
3	=SIGN(0) = 0
4	=SIGN(-2) = -1
5	=SIGN(-0.555) = -1
6	=SIGN((-2)*(-1)) = 1
7	=SIGN("text") = #VALUE!

1 - What is the sign of the value 100.
2 - What is the sign of the value 4.
3 - What is the sign of the value 0.
4 - What is the sign of the value -2.
5 - What is the sign of the value -0.555.
6 - What is the sign of the value -2 multiplied by -1.
7 - If "number" is not numeric.