Exceljet

Quick, clean, and to the point

Excel EVEN Function

Excel EVEN function
Summary 

The Excel EVEN function returns the next even integer after rounding a given number up. The EVEN function always rounds numbers up (away from zero) so positive numbers become larger and negative numbers become smaller (i.e. more negative).

Purpose 
Round a number up to the next even integer
Return value 
An even integer.
Syntax 
=EVEN (number)
Arguments 
  • number - The number to round up to an even integer.
Usage notes 

The EVEN function always rounds up to the next even integer, skipping odd integers along the way. Note that negative numbers are rounded "up" away from zero, so they actually become more negative.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.