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.
- 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.
Here I have used different arguments for this function.
- When you refer to negative values, it will always round them to lower even number, away from zero.
- When you refer to positive values it will always round them to the upper even number.
- And, when you refer to a zero it will remain same.
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.