Ifnumberis positive, SIGN returns 1.
Ifnumberis negative, sign returns -1.
Ifnumberis zero, SIGN returns 0.
The SIGN function takes one argument,number, which must be a numeric value.
Ifnumberis not numeric, SIGN returns a #VALUE!
Examples
SIGN can be used to change negative numbers into positive values like this.
