Description
Use this function to return the sign of a number as +1, -1 or 0. Supported in Chains.
If number is positive, SIGN returns 1.
If number is negative, sign returns -1.
If number is zero, SIGN returns 0.
If number is not numeric, SIGN returns a #VALUE! error.
Syntax
SIGN(number)
Inputs
This function has the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number |
Yes | The initial value to be used. | A cell reference, a number, or a formula which results in either of these. |
Examples
Sample data
Sample data
| A | B | |
|---|---|---|
1 |
34 |
0 |
2 |
-2 |
39 |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Determine the sign of a positive number. | =SIGN(4) |
This formula works in the following manner:
For this data set, the formula returns 1. |
| Determine the sign of a negative number in a cell. | =SIGN(A2) |
This formula works in the following manner:
For this data set, the formula returns -1. |
| Determine the sign of zero in a cell. | =SIGN(B1) |
This formula works in the following manner:
For this data set, the formula returns 0. |
Notes
- Wildcards don't work with this function.
Related functions
ABS
EXP
LN
MOD
N
POWER
PRODUCT
SQRT
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT