Google Sheets
SIGN function in Google Sheets
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
=SIGN(value)SIGN syntax and parameters
One argument, one required.
- valuenumberRequired
The value whose sign will be evaluated.
SIGN examples
Formulas you'll actually reuse.
−1, 0, or 1 for below, on, or above target:
=SIGN(B2 - C2)Result
1How many rows came in under target:
=SUMPRODUCT(--(SIGN(B2:B50 - C2:C50) = -1))Result
12
SIGN in Excel
Same name — your formula ports as-is.
Try SIGN in the playground
Edit the example — nothing to install.
Preloaded with the SIGN formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel