SIGN

  • Updated

Returns the sign of a given number. Returns 1 for a positive number, -1 for a negative number, and 0 (zero) if the number is 0.

Sample Usage

SIGN(10)
SIGN(-10)
SIGN(C5)

Syntax

SIGN(number)

  • number - The number for which the sign is to be examined.

Examples

SIGN(10) returns the sign of 10 i.e 1.
SIGN(-10) returns the sign of 10 i.e -1.
SIGN(C5) returns the tangent of the number contained in C5.