SIGN()
function returns a sign of an argument. The returned values are -1 if the argument is less than zero, 1 if the argument is greater than zero, 0 if the argument is equal to zero.
SIGN()
function is as follows:
SIGN()
function requires one argument:
x
: an expression that evaluates to a number.SIGN()
function can be used to obtain the sign of a number:
-0
is accepted as an argument and is equal to zero
SIGN()
function can be used with an expression:
SIGN()
function can be used with a table to obtain the absolute values of all numbers in a specific column: