Formulas and Functions
Modifying this control will update this page automatically

SIGN

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.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.