Skip to main content

SIGN function

The SIGN function is one of the math and trigonometry functions. It is used to return the sign of a number. If the number is positive, the function returns 1. If the number is negative, the function returns -1. If the number is 0, the function returns 0.

Syntax​

SIGN(number)

The SIGN function has the following argument:

ArgumentDescription
numberA numeric value for which you want to get the sign.

Notes​

How to apply the SIGN function.

Examples​

The required argument is A1, where A1 is 12. The number is positive, so the function returns 1.

SIGN Function: POSITIVE

If we change the A1 value from 12 to -12, the function returns -1:

SIGN Function: NEGATIVE