SIGN

SIGN(number)

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

numberThe 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!


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