Export (0) Print
Expand All
Expand Minimize

Sgn Function

Last modified: December 06, 2011

Applies to: Office 2013 | VBA

Returns a Variant (Integer) indicating the sign of a number.

Syntax

Sgn( number )

The required number argument can be any valid numeric expression.

Return Values

If number is

Sgn returns

Greater than zero

1

Equal to zero

0

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.
Show:
© 2014 Microsoft