EVEN 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 >

EVEN

Rounds a number up, away from zero, to the next even integer.

Syntax:

EVEN(number)

returns number rounded to the next even integer up, away from zero.

Example:

EVEN(2.3)

returns 4.

EVEN(2)

returns 2.

EVEN(0)

returns 0.

EVEN(-0.5)

returns -2.

---

See Also

• CEILING
• FLOOR
• ODD
• MROUND

• INT
• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category