Excel: Sign Function
In Excel, the Sign function returns the sign of a number. If the number is positive, the Sign function will return 1. If the number is negative, the Sign function will return -1. If the number is 0, the Sign function will return 0.
The syntax for the Sign function is:
Sign( number )
number is the number that you wish to return the sign for.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Sign(A1) would return 1 =Sign(A2) would return 0 =Sign(A3) would return -1 =Sign(99) would return 1