Excel Function : SIGN
Category
Math and trigonometry
Description
Returns the sign of a number
Microsoft Excel Reference Page
https://support.office.com/en-us/article/SIGN-function-109c932d-fcdc-4023-91f1-2dd0e916a1d8
Syntax and Description of the SIGN Excel Function
The syntax for the SIGN function in Excel is: =SIGN(number) The number argument is the number whose sign you want to return.
About SIGN Excel Function
SIGN(number) The SIGN function returns the sign of a number. A positive number returns 1, a negative number returns -1, and zero returns 0.