Sgn
Indicates the sign of a number. Sgn does not round the number, and ignores the fractional value of the number.
Sgn expects the argument (Num) to be a valid numeric value. If Num is greater than zero, Sgn returns the value of 1. If Num is equal to zero, Sgn returns the value of 0. If Num is less than zero, Sgn returns the value of -1.
Syntax
Sgn(Num)
Num:
An Integer or expression representing a valid numeric value.
Return Value
Returns a value indicating the Sign (+ or - ) value of the (Num) provided in the argument.
Related Functions
Example
Dim vntVal
vntVal = Sgn(99.8) ' returns 1
vntVal = Sgn(-99.8) ' returns -1
vntVal = Sgn(0) ' returns 0