Math and Trignometric - SIGN Function

Description

The SIGN function determines the sign of a number. The function returns −

  • 1 if the number is positive
  • zero (0) if the number is 0
  • -1 if the number is negative

Syntax

SIGN (number)

Arguments

Argument Description Required/Optional
Number Any real number. Required

Notes

If the specified number is not recognized as a numeric value, SIGN returns #VALUE! error.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

SIGN Function
advanced_excel_math_trigonometric_functions.htm
Advertisements