Excel SIGN function

Function              SIGN

Description        Excel SIGN function returns the sign of a number. If the number is positive it returns 1, returns 0 if it is 0, -1 if the number is negative.

Syntax  SIGN(number)

number  The numerical value which sign to be returned.

Example:

=SIGN(9.54)=1

=SIGN(-9.54)=-1