Excel EVEN Function

Using the Excel EVEN Function


The EVEN function returns a number that is rounded up to the nearest even integer. EVEN will always round numbers up (i.e. away from zero). This means that positive numbers become larger and negative numbers become smaller. Use the ODD function if you need to round to the next odd integer.


=EVEN (number)

Syntax Breakdown

The number argument is required in the EVEN function. This is the number that you would like to round.

Usage Notes

The EVEN function returns the nearest even integer of a given number when it is rounded up. If the number is already even, no rounding will take place. If the number is non-numeric, then the #VALUE! error will be returned by the function.

Excel EVEN Error