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

SIGN (number) 

number – The number from which the arithmetic sign to be

 

Example of SIGN Function in Excel

Formula

SIGN Function in Excel 1

  • 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

SIGN F unction in Excel 2

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

previous-small SIGN Function in Excel                                                                                                                next_small SIGN Function in Excel