Skip to Content

SIGN

Returns the sign of a number: 1 if positive, 0 if zero, or -1 if negative

Syntax

SIGN(number)

Parameters

  • number: Required. Any real number

Example

=SIGN(-10)
Returns: NumberSince: Excel 2003