SIGN function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• COS
• SIN
• TAN
• COT
• ACOS
• ACOT
• ASIN
• ATAN
• ATAN2
• DEGREES
• RADIANS
• PI

Hyperbolic

• COSH
• SINH
• TANH
• COTH
• ACOSH
• ACOTH
• ASINH
• ATANH

Rounding and remainders

• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP
• CEILING
• FLOOR
• EVEN
• ODD
• MROUND
• INT
• QUOTIENT
• MOD

Logarithm/Powers

• EXP
• POWER
• LOG
• LN
• LOG10

Bessel functions

• BESSELI
• BESSELJ
• BESSELK
• BESSELY

Miscellaneous

• ABS
• COMBIN
• COMBINA
• CONVERT
• CONVERT ADD
• COUNTBLANK
• COUNTIF
• DELTA
• ERF
• ERFC
• FACT
• FACTDOUBLE
• GCD
• GCD ADD
• GESTEP
• ISEVEN
• ISODD
• LCM
• LCM ADD
• MULTINOMIAL
• PRODUCT
• RAND
• RANDBETWEEN
• SERIESSUM
• SIGN
• SQRT
• SQRTPI
• SUBTOTAL
• SUM
• SUMIF
• SUMSQ

< Previous Page

Next Page >

SIGN

Returns the sign of a number:- 1 if the number is positive, -1 if negative and 0 if zero.

Syntax:

SIGN(number)

number is the number whose sign is to be determined.

Example:

SIGN(3.4)

returns 1.

SIGN(-4.5)

returns -1.

SIGN(0)

returns 0.

---

See Also

• ABS

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category