The EVEN Function Explained

beautiful calm clouds dark

  • Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. 

This post outlines how the EVEN function works, including a summary of this function, important conditions to keep in mind when using it as well as an example for you to play around with.

A panoramic view of the evening sky - symbolises the EVEN Function.
Image by RitaE from Pixabay.

Summary of the EVEN Function

The EVEN function works by gathering a number rounded up to the closest even integer. You can employ this function for reviewing items that come in pairs. For instance, a packing crate takes rows of one or two items. The crate becomes full once the number of items, rounded up to the nearest two, equals the crate’s capacity.

Syntax of the EVEN Function


The EVEN function syntax includes these specific arguments:

  • Number  –  Required. The desired value to round.
A reflection of a sunset - represents the EVEN function.
Image by blizniak from Pixabay.

Important conditions of its use

  • If number is nonnumeric, EVEN yields the #VALUE! error value.
  • Irrespective of the sign of number, a value is rounded up after modified away from zero. If number is an even integer, then no rounding happens at all.


Copy the sample data in the table underneath, and paste it into cell A1 of an unused Excel worksheet. For formulas to present results, choose them, press F2, and then press Enter. If you have to at any point, you can amend the column widths to view the whole data without having to constantly go back and forth.

=EVEN(1.5)Rounds 1.5 to the nearest even integer.2
=EVEN(3)Rounds 3 to the nearest even integer.4
=EVEN(2)Rounds 2 to the nearest even integer.2
=EVEN(-1)Rounds -1 to the nearest even integer.-2

Other Similar Functions






Other Links

Back to Software Bytes – Official Website

Back to Excel Tutorial

Leave a Reply

%d bloggers like this: