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


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