The SIGN function returns 1 when the argument number is positive, –1 when it is negative, and 0 when it is zero.
SIGN(num)
num: A number value.
Examples |
|---|
=SIGN(2) returns 1. =SIGN(0) returns 0. =SIGN(-2) returns -1. =SIGN(A4) returns -1, if cell A4 contains -2. |