How to use Excel EVEN Function

how to use excel even function

Quick Intro

Use Excel EVEN Function to round a number to a nearest even number.

For Example, it will round 5.1 to 6 and 3.1 to 4.

Syntax

EVEN(number)

  • number A number value which you want to round.

More Information on Excel EVEN Function

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

Examples

Here I have used different arguments for this function.

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.

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel EVEN Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have ISEVEN function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.