When you work in Excel spreadsheets, it’s often useful to round numbers up to the nearest even integer. By using even numbers, you can maintain consistency in a given dataset. Fortunately, Excel has a built-in function to do this quickly. Let’s learn **how to use EVEN in Microsoft Excel.**

## How to Use EVEN in Excel

Even numbers – 2, 4, 6, and so on – are commonly used units when processing a variety of data types. For example, you may be working with items in pairs. Having an odd number won’t work, so it’s useful to round to the nearest even integer value. This is where Excel’s **EVEN** function comes in.

**EVEN** is a simple function with one purpose: it rounds a given value up to the nearest even integer value. Let’s look at a few examples to illustrate how it works.

For example, imagine that you have a list of values that you need to round up to the nearest even value. To use the **EVEN** function, click into any empty cell in your workbook.

Then, type an **=** sign. This tells Excel that you’re inputting a formula into the cell. Then, type **EVEN(**. So far, your formula reads:

=EVEN(

Then, click into the cell containing the value that you want to round to an even integer. In this example, the first value is in cell **A1**. Type** )**, completing your formula as:

=EVEN(A1)

Hit **Enter**, and Excel will display the rounded-up even integer value in the cell containing the formula: **4**.

From here, you can drag your formula downward to capture the other two values. Notice that **-3** rounds up to **-4**. Also, since **4** is already an even integer, the **EVEN** function returns the identical value of **4**.

As you can see, **EVEN** in Excel is a quick and powerful way to round numbers to the nearest even integer value.