Excel Function : SIGN

Download now!

Excel Function : SIGN


Math and trigonometry


Returns the sign of a number

Microsoft Excel Reference Page


Syntax and Description of the SIGN Excel Function

The syntax for the SIGN function in Excel is: =SIGN(number) The number argument is the number whose sign you want to return.

About SIGN Excel Function

SIGN(number) The SIGN function returns the sign of a number. A positive number returns 1, a negative number returns -1, and zero returns 0.