The VBA SGN Function
Related Function:
VBA Abs
Description
The VBA Sgn function returns an integer (+1, 0 or -1), representing the arithmetic sign of a supplied number.
The syntax of the function is:
Sgn( Number )
Where the Number argument is the number that you want the arithmetic sign of.
VBA Sgn Function Examples
|
' Return the arithmetic sign of the numbers 5, 0 and -0.1
Dim int1 As Integer
Dim int2 As Integer Dim int3 As Integer
int1 = Sgn( 5 )
' Now, int1 = 1, int2 = 0 and int3 = -1
int2 = Sgn( 0 ) int3 = Sgn( -0.1 ) |
In the above VBA code:
- When provided with the number 5, the Sgn function returns the value 1;
- When provided with the number 0, the Sgn function returns the value 0;
- When provided with the number -0.1, the Sgn function returns the value -1.
VBA Sgn Function Error
If the Sgn function is supplied with a value that cannot be interpreted as a number, it will return the error:
Run-time error '13': Type mismatch
