Appearance

EVEN function ​

Overview ​

EVEN is a function of the Math and Trigonometry category that rounds a number up (away from zero) to the nearest even integer.

Usage ​

Syntax ​

EVEN(number) => even

Argument descriptions ​

  • number (number, required). The number that is to be rounded to the nearest even integer.

Additional guidance ​

  • EVEN rounds away from zero, meaning:
    • Positive numbers are rounded up to the next even integer.
    • Negative numbers are rounded down (toward negative infinity) to the next even integer.
  • If the number argument is already an even integer, EVEN returns it unchanged.
  • Since zero is considered an even number, the EVEN function returns 0 when number is 0.

Returned value ​

EVEN returns a number that is the nearest even integer, rounded away from zero.

Error conditions ​

  • In common with many other IronCalc functions, EVEN propagates errors that are found in its argument.
  • If no argument, or more than one argument, is supplied, then EVEN returns the #ERROR! error.
  • If the value of the number argument is not (or cannot be converted to) a number, then EVEN returns the #VALUE! error.
  • For more information about the different types of errors that you may encounter when using IronCalc functions, visit our Error Types page.