Start Free Course
How-to-Use-EVEN-Excel-Function-Basic-Example

EVEN Function in Excel

Written by ExcelMojo Editorial Team ExcelMojo Editorial Team ExcelMojo editorial profile and article credentials. Full Bio
Reviewed by Dheeraj Vaidya, CFA, FRM Dheeraj Vaidya, CFA, FRM Reviewed for accuracy, clarity, and editorial standards. Full Bio
Updated Apr 23, 2026
Read Time 8 min

What is EVEN Function in Excel?

The Excel EVEN function rounds up numbers to the next even integer away from zero. Therefore, in the case of positive numbers, they become larger, while the negative ones are rounded to a more negative number. For instance, =EVEN(3) returns 4 while =EVEN(-3) returns -4.

Consider a few numbers below in Column A, which can be rounded off to the nearest even integer. Enter the formula =EVEN(A2) in cell B2. Press Enter and drag the Autofill handle up to B5. You observe that the numbers have been rounded off to the next even integer away from zero.

Frequently Asked Questions (FAQs)

1. What is the purpose of Excel EVEN Function?

The Excel EVEN function rounds off numbers to the next even integer, whether the number is positive or negative. Also, it rounds off the numbers away from zero.

2. Why is Excel EVEN Function not working?

The EVEN function should be supplied with only one numeric argument. If you provide a non-numeric value to it, you get an #VALUE! Error. Thus, the Excel EVEN function not working scenario may arise. Also note that if the number supplied as an argument is already an even number, the output is the same.

3. What is the difference between Excel EVEN Function and Excel ODD Function?

The functions EVEN() and ODD() in Excel are part of the Math and Trig group and work similarly. However, while the Excel EVEN function rounds off a number to the next even integer, the Excel ODD function rounds off a number to the following odd number.

Download Template

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

Guide to EVEN Function in Excel. Here we explain how to use EVEN Formula along with examples and downloadable excel template. You can learn more from the following articles –