**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.