Syntax: Sign ( number )
numberAny expression that resolves to a numeric value.
Data type returned: Text
Returns a value that represents the sign of number:
-1 when number is negative
0 when number is zero
1 when number is positive
For any x other than 0, multiplying x by Sign(x) yields the Abs(x).
Returns -1 for the formula If (Sign (BalanceDue) = -1; "Please pay now!"; "Thanks for your payment!").