SIGN

Get the sign of a number.

Sponsored Link

Purpose 

Get the sign of a number.

Return value 

One if positive. Negative one if negative. Zero if zero.

Syntax 

=SIGN (number)

Arguments 

  • number - The number to get the sign of.

Usage notes 

If the number is in the range (-∞,0) SIGN(number) will return -1.

If the number is equal to 0 SIGN(number) will return 0.

If the number is in the range (0,∞)(number) SIGN will return 1.

Sponsored Link

0 votes. 0 / 5