Table of contents
Collapse the table of content
Expand the table of content

Sgn Function

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Returns a Variant ( Integer ) indicating the sign of a number. SyntaxSgn(number) The required numberargument can be any validnumeric expression. Return Values

If number isSgn returns
Greater than zero1
Equal to zero0
Less than zero-1

Remarks The sign of the number argument determines the return value of the Sgn function.


This example uses the Sgn function to determine the sign of a number.

Dim MyVar1, MyVar2, MyVar3, MySign
MyVar1 = 12: MyVar2 = -2.4: MyVar3 = 0
MySign = Sgn(MyVar1)    ' Returns 1.
MySign = Sgn(MyVar2)    ' Returns -1.
MySign = Sgn(MyVar3)    ' Returns 0.
© 2017 Microsoft