SIGN Function in Excel – Get the Sign of the number in Excel

SIGN function in Excel returns the arithmetic sign of a supplied number. If the number is positive, the SIGN function returns +1, if the number is negative, the function returns -1 and if the number is 0 (zero), the function returns 0.

Syntax of SIGN Function in Excel

number – The number from which the arithmetic sign to be

 

Example of SIGN Function in Excel

Formula

• Row number 2,3 and 4 have negative values so the SIGN Function returns -1
• Row number 5 have zero so the SIGN Function returns 0
• Row number 6 and 7 takes up Positive values so the SIGN Function returns 1

Result

Note: #VALUE! Error occurs if the supplied number argument is non-numeric.