The EVEN Function Overview
Rounding numbers in Excel can be accomplished using a number of different rounding functions depending on the results you want.
The function also rounds odd number integers to the next even integer.
Rounding Positive vs. Negative Numbers
The function works by rounding numbers away from zero regardless of whether a number is negative or positive.
Rounding away from zero results in positive numbers being rounded up to the next highest even integer while negative numbers are rounded down to the next lowest even negative integer.
Rounding Data and Calculations
The EVEN function can, therefore, affect the results of other calculations in a worksheet that make use of the rounded data.
The EVEN Function's Syntax and Arguments
The syntax for the EVEN function is:
= EVEN ( Number)
Note: If data entered for the Number argument is not a number, the function returns the #VALUE! error value.
EVEN Function Examples: Rounding to the Nearest Even Integer
As shown in the image above, two of the three examples will use the EVEN function to round the positive numbers 27.357 and 9 up to the next highest even integers (28 and 10 respectively).
The third example will use the function to round the negative number -4.431 down to the next smallest even negative integer (-6).
Entering the DataEnter the following data into the designated cells as shown in the image above.
Cell Data D1 27.357 D2 9 D3 -4.431
Entering the EVEN Function
- Click on cell E1 to make it the active cell - this is where the results of the first EVEN function example will be displayed
- Click on the Formulas tab of the ribbon menu
- Choose Math & Trig from the ribbon to open the function drop down list
- Click on EVEN in the list to bring up the function's dialog box
- In the dialog box, click on the Number line
- Click on cell D1 in the worksheet to enter that cell reference into the dialog box
- Click OK
- The answer 28 should appear in cell E1 since this is the next highest even integer after 27.357
- When you click on cell E1 the complete function = EVEN ( D1 ) appears in the formula bar above the worksheet.
Copying the Formula with the Fill Handle
Rather than recreate the formula for the other two examples, the first formula can quickly copied using the Fill Handle.
- Click on cell E1 to again make it the active cell
- Place the mouse pointer over the black square in the bottom right corner of cell E1. The pointer will change to a plus sign " + "
- Press and hold down the left mouse button while dragging the fill handle down to cell E3
- Release the mouse button
- Cell E2 should contain the answer 10 since this is the next even integer
after the number 9
- Since the EVEN function always rounds both positive and negative numbers away from zero, cell E3 contains the answer -6 since this is the next even integer after -4.431