PrecisionCalc
xl
Precision
Get Your Numbers Right
xlpSIGN
Determines the sign of a number, with up to 32,767 significant digits of precision.
Returns:
1 for positive numbers
-1 for negative
numbers
0 for 0
0 for blank cells
"#VALUE!" for cells that are not blank but not a number.
Syntax
xlpSIGN(num)
| num | Required. The number for which the sign will be found. |
Remarks
Returns the error "#VALUE!" if cell is not blank but not a number.
num can accept both numbers and text.
num can accept text formatted with the local currency symbol and thousands separators, and negatives can be formatted with either a leading hyphen or parentheses.
num can accept text up to 32,767 characters long.
Examples
| Formula | Description | Result |
| =xlpSIGN(5) | Return 1, 0, or -1, depending on whether 5 is positive, zero, or negative. | 1 |
| =xlpSIGN(-5) | Return 1, 0, or -1, depending on whether -5 is positive, zero, or negative. | -1 |
| =xlpSIGN(0) | Return 1, 0, or -1, depending on whether 0 is positive, zero, or negative. | 0 |
| =xlpSIGN("($123,456,789,123,456,789,123,456,789)") | Return 1, 0, or -1, depending on whether 0 is positive, zero, or negative. | -1 |
See Also