How to use Excel EVEN Function

How to use Excel EVEN Function2016-04-29T10:25:09+00:00

The EVEN function to rounds a number to a nearest even number. For example, it will round 5.1 to 6 and 3.1 to 4.

Syntax

EVEN(number)

  1. number A number value which you want to round.

Example

Here we have used different arguments for EVEN.

examples for excel even function
  1. When you refer to negative values, it will always round them to lower even number, away from zero.
  2. When you refer to positive values it will always round them to the upper even number.
  3. And, when you refer to a zero it will remain same.

Remember

  1. If you specify a value other than a number it will return a #VALUE! error.
  2. You can also insert a numeric value directly into the function by using double quotes or even without using them.
Content Protection by DMCA.com
>