Functions
SIGN
Sign of a number: -1, 0, or 1
Try it
When to use it
When should I use SIGN?
Use SIGN to determine whether a number is positive, negative, or zero — it returns 1, -1, or 0, which is useful for branching logic or directional calculations.
Used in
Syntax
SIGN(number)Examples
=SIGN(-42) // => -1
=SIGN(42) // => 1
=SIGN(0) // => 0