by Sign function in excel is a Maths/Trig function that is used to give us this result. SIGN function returns the sign (-1, 0 or +1) of the supplied numerical argument. SIGN formula in excel can be used by typing the keyword =SIGN( and providing the number as input.
Syntax: =SIGN (number)
The SIGN function syntax has the following arguments:
- The number that you wish to return the sign for.
Example: Let’s look at some Excel SIGN function examples and explore how to use the SIGN function as a worksheet function in Microsoft Excel:
Syntax: =SIGN(A2)
Result:
Based on the Excel spreadsheet above, the following SIGN examples would return:
Syntax: =SIGN(A3)
Result: 1
Syntax: =SIGN(A4)
Result: -1
Syntax: =SIGN(A5)
Result: 1
Syntax: =SIGN(A6)
Result: -1
Syntax: =SIGN(A7)
Result: -1
Syntax: =SIGN(A8)
Result: 1
Syntax: =SIGN(A9)
Result: 1
Syntax: =SIGN(A10)
Result: 0
Syntax: =SIGN(A11)
Result: -1
Note:
- If the number is in the range (-∞,0) SIGN(number) will return -1.
- If the number is equal to 0 SIGN(number) will return 0.
- If the number is in the range (0,∞)(number) SIGN will return 1.
