How To Round Up Or Down To The Nearest Even Integer In Excel Explained -How To Use The EVEN function
In this video we discuss how to round up or down to the nearest even integer using the EVEN function. We go through several different examples, including negative numbers and decimals
Transcript/notes
The Even function rounds a positive number up and a negative number down to the nearest even integer. As an example here in cell A2 is the number 7, I am going to use the EVEN function referencing this cell, so I left click on cell B2. Next type in an equals sign, then type in the letters ev. Now, in the drop down box, left double click on the word even.
From here you left click cell A2, then type in a closed parenthesis. And to finish, hit the enter key, and we have our answer of 8.
I’ll use the fill handle to fill in the rest of the column.
As you can see, for -3, the output is -4, as it rounds negative numbers down to the nearest even integer. If the number is already an even number there is no change. And when an even number has a decimal, such as in cells A6 and A7, it still rounds up or down depending on positive or negative.
Chapters/Timestamps
0:00 What is the EVEN function?
0:13 How to use the EVEN function
0:33 More examples of the EVEN function
