To use this function, choose Calc > Calculator.

Converts negative numbers, zero, and positive numbers to −1, 0, and +1, respectively. You can use the Signs function to code the numbers in a column. This function is useful in macros, formulas, and nonparametric analyses.



For number, specify the number or column of numbers you want to convert.


Calculate expression Result
SIGN(452) 1
SIGN(-0.66) −1
SIGN(0) 0

In a different example, you want to code the column Days from expected arrival to early (−1), late (+1), or on time (0). In the Calculator enter the expression: SIGN (C2). Store the results in C3.

C2 C3
Days from expected arrival SIGNS values
−2 −1
−1 −1
3 1
0 0
2 1
−3 −1
0 0
−5 −1
−2 −1
1 1
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy