In Microsoft Excel, the SIGN number is a math and trigonometry function that returns the sign of a number. The SIGN function returns 1 if the number is positive, zero if the number is 0, and -1 if the ...
Sign function is supposed to return 1 or -1 depending if the given value is positive or negative. Seems like the sign function does not contain logic to handle values that are exactly 0, so the result ...