SIGN Function Explained

The SIGN function in Microsoft Excel returns the sign of a number. It takes a single argument, a number, and returns 1 if the number is positive, 0 if the number is 0, and -1 if the number is negative.

SIGN Function Syntax

SIGN(number)

  • number: The number whose sign is to be returned. The number can be positive, negative, or zero.