SIGN Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2
Example 3
Example 4

Returns a value that represents the sign of a number.

SIGN(number,fuzz)

Parameters

Name

Required/Optional

Data Type

Description

number

Required

Numeric

The number for which you want to determine the sign.

fuzz

Optional

Numeric

Specifies how close to zero the number must be in order to be considered equal to zero.

Return Value

Numeric

The SIGN function returns 1 if number is positive, 0 if number is zero, or -1 if number is negative.

Specifyin a fuzz value helps avoid floating-point roundoff errors when a calculation is almost zero. If you do not specify a fuzz value, Visio uses 1E-9 (0.000000001). You may want to supply a different value when you scale drawings or when you want an exact comparison.

SIGN(-5)

Returns -1.

SIGN(0)

Returns 0.

SIGN(0.00000000001)

Returns 0.

SIGN(0.00000000001,0)

Returns 1.

Show: