The SIGN function determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.

SIGN takes 1 required argument and no optional arguments:

Syntax: SIGN(number)

#1)
Using the SIGN function:
#2)
The arguments for the SIGN function are:
Argument Required? Description
number Required Any real number.

Summary

The SIGN function determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.
comments powered by Disqus