Related Function:

The SIGN function returns the sign (+1, -1 or 0) of a supplied number. Ie. if the number is positive, the SIGN function returns +1, if the number is negative, the function returns -1 and if the number is 0 (zero), the function returns 0.

Syntax

=SIGN(number)

Arguments

Argument Description
number Any numerical value and can be supplied to the function as either a simple number, a reference to a cell containing a numbers, or as a numeric value returned from another function

Examples

  A B C D
1 Number Formula Result Notes
2   =SIGN(12.5) 1  
3 -12.5  =SIGN(A3) -1  
4   =SIGN(0) 0  
5   =SIGN(SUM(3,-6) -1  
6 =SUM(3,-6) =SIGN(A6) -1  
7   =SIGN(“-12.5”) -1 The value -12.5 is entered as a text string