1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel EVEN Function Tutorial


Round Numbers to the Next Even Integer
Excel EVEN Function Tutorial

Excel EVEN Function Tutorial

© Ted French

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 EVEN function can be used to round decimal numbers to an even integer while removing the decimal portion of the number.

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

Unlike formatting options that only alter the appearance of data by changing the number of decimal places displayed; the EVEN function actually alters the data in your worksheet.

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

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the EVEN function is:

= EVEN ( Number)

Number - (required) the value to be rounded. This argument can contain the actual data for rounding or it can be a cell reference to the location of the data in the worksheet.

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 Data

Enter 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

  1. Click on cell E1 to make it the active cell - this is where the results of the first EVEN function example will be displayed

  2. Click on the Formulas tab of the ribbon menu

  3. Choose Math & Trig from the ribbon to open the function drop down list

  4. Click on EVEN in the list to bring up the function's dialog box

  5. In the dialog box, click on the Number line

  6. Click on cell D1 in the worksheet to enter that cell reference into the dialog box

  7. Click OK

  8. The answer 28 should appear in cell E1 since this is the next highest even integer after 27.357

  9. 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.

  1. Click on cell E1 to again make it the active cell

  2. Place the mouse pointer over the black square in the bottom right corner of cell E1. The pointer will change to a plus sign " + "

  3. Press and hold down the left mouse button while dragging the fill handle down to cell E3

  4. Release the mouse button

  5. Cell E2 should contain the answer 10 since this is the next even integer
    after the number 9

  6. 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

©2014 About.com. All rights reserved.