EVEN function in Excel

Syntax

=EVEN(number)

Example

=ODD(4) is 5, =EVEN(7) is 8 and =ISEVEN(4) is TRUE.

From the lesson ODD and EVEN Functions.

Common mistakes

• Thinking ODD(5) changes 5 (it is already odd).
• Expecting ROUND-like behaviour: ODD/EVEN always round away from zero.

Related math functions

• SUMAdds all the numbers in a range.
• SUMIFAdds the cells that meet one condition.
• SUMIFSAdds the cells that meet several conditions.
• SUMPRODUCTMultiplies matching items and returns the sum of those products.
• ROUNDRounds a number to a given number of digits.
• ROUNDUPRounds a number up, away from zero.
• ROUNDDOWNRounds a number down, toward zero.
• FLOORRounds down to the nearest multiple of significance.