Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
Sample Usage
SIGN(-42)
SIGN(A2)
Syntax
SIGN(value)
-
value
- The value whose sign will be evaluated.
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
SIGN(-42)
SIGN(A2)
SIGN(value)
value
- The value whose sign will be evaluated.Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.