SIGN
Returns the sign of a number.
Math & TrigonometryMath Basics
What it does
Returns 1 (positive), 0 (zero), or -1 (negative).
Syntax
SIGN(number)
Arguments
number(number) — Value.
Examples
Check Sign
Sign of -10.
FORMULA
=SIGN(-10)
RESULT
-1
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | -10 |