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:
Based on the Excel spreadsheet above, the following SIGN examples would return:
- 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.