Returns the sign of a number
Syntax Sgn(Number) Key Number The number to return the sign of.
If number > 0, then Sgn() will return 1.
If number = 0, then Sgn() will return 0.
If number < 0, then Sgn() will return -1.
The Sgn() function may be used in VBA or in an SQL query.
Dim intDemo as Integer
intDemo = Sgn(64)
“One of the main causes of the fall of the Roman Empire was that, lacking zero, they had no way to indicate successful termination of their C programs” ~ Robert Firt
GetAttr - Get file/folder attributes
© Copyright SS64.com 1999-2013
Some rights reserved