SIGN Function

The SIGN function checks if the given number is positive or negative.

Formula:


=SIGN(Value)
The function returns 1 for positive values, -1 for negative values and 0 for 0.

Video Tutorial:


Let us check if the given number is positive or negative, using the SIGN function, with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question