Excel VBA Sgn Function
VBA Sgn Function: The Sgn function in VBA returns an integer (+1, 0, or -1), stating the arithmetic sign for the specified number.
Syntax
Sgn (Number)
Parameter
Number (required) –This parameter represents the number that you want the arithmetic sign of.
Return
This function returns an integer (+1, 0, or -1), stating the arithmetic sign for the specified number.
Example 1
Sub SgnFunction_Example1() ' It will return the arithmetic sign of the number. Dim sgn_int As Integer sgn_int = Sgn(15) ' The variable sgn_int will return 1 Cells(1, 1).Value = sgn_int End Sub
Output
1
Example 2
Sub SgnFunction_Example2() ' It will return the arithmetic sign of the number. Dim sgn_int As Integer 'for negative numbers sgn_int = Sgn(-15) ' The variable sgn_int will return -1 Cells(1, 1).Value = sgn_int End Sub
Output
-1
Example 3
Sub SgnFunction_Example3() ' It will return the arithmetic sign of the number. Dim sgn_int As Integer 'for number equal to zero sgn_int = Sgn(0) ' The variable sgn_int will return 0 Cells(1, 1).Value = sgn_int End Sub
Output
0