SIGN

SIGN(number)

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

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

	A
1	=SIGN(4) = 1
2	=SIGN(-2) = -1
3	=SIGN(0) = 0
4	=SIGN(-2*-1) = 1
5	=SIGN(10) = 1
6	=SIGN("some text") = #VALUE!