PrecisionCalc
xl
Precision

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