How to use EVEN Function in Excel

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.



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


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.


  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.