The Excel SIGN function returns the sign of a number as +1, -1 or 0. If number is positive, SIGN returns 1. If number is negative, sign returns -1. If number is zero, SIGN returns 0.
Get over 100 Excel Functions you should know in one handy PDF.
Quick, clean, and to the point.