Returns the sign of a number.
Sintaxe
SIGN(number)Argumentos
numberobrigatório
The number you want to test.
The SIGN function determines whether a number is positive, negative, or zero. It returns 1 if the number is positive, -1 if the number is negative, and 0 if the number is zero.
=SIGN(10)→1Since 10 is a positive number, the function returns 1.
=SIGN(-5)→-1Since -5 is a negative number, the function returns -1.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =SIGN(number) and replace 'number' with the value or cell reference you want to evaluate.
Press Enter
Press Enter to see the sign of the number.
The SIGN function returns 0 when the input is 0.