ISEVEN
Information
Returns TRUE if the number is even.
Translations
EnglishISEVEN
FrenchEST.PAIR
SpanishES.PAR
GermanISTGERADE
ItalianPARI
PortugueseÉPAR
DutchIS.EVEN
PolishCZY.PARZYSTE
RussianЕЧЁТ
TurkishÇİFTMİ
CzechJE.SUDÉ
HungarianPÁROS
SwedishÄRJÄMN
DanishER.LIGE
FinnishONPARILLINEN
Syntax
ISEVEN(number)Arguments
numberNumber to test
Examples
=ISEVEN(4)TRUE
4 is even
=ISEVEN(3)FALSE
3 is not even
=ISEVEN(ROW())Alternating
TRUE for even rows
Tips & Best Practices
- •Useful for alternating row colors
- •Decimals are truncated first
- •ISEVEN(0) returns TRUE
Common Mistakes
- •Applying ISEVEN to a non-integer number expecting an error - it truncates the decimal portion first, so ISEVEN(4.9) evaluates the number 4 and returns TRUE
- •Using ISEVEN on text that looks numeric but hasn't been converted, which returns a #VALUE! error since ISEVEN requires a genuine number
- •Forgetting that 0 is considered even by ISEVEN, which surprises some people expecting a boundary case or error since zero is neither clearly positive nor negative
Related Functions
ISODDChecks for the opposite condition, returning TRUE for odd numbers instead of even ones.MODCan replicate the same check manually with MOD(number,2)=0, the underlying logic ISEVEN is built on.INTRelated to how ISEVEN handles non-integer input, since the decimal portion is effectively truncated before the even/odd check happens.Frequently Asked Questions
Does ISEVEN consider 0 an even number?
Yes, ISEVEN(0) returns TRUE - zero is mathematically even, which can surprise people who expect it to be a special edge case.
What does ISEVEN do with a decimal number like 4.9?
It truncates the decimal first, evaluating the number as 4, and returns TRUE - the decimal portion is ignored rather than causing an error.
Why does ISEVEN return #VALUE!?
The input isn't a genuine number - it's likely text that looks numeric but hasn't been converted, which VALUE can fix first.
Need to translate a formula using ISEVEN?
Use our translator to convert your complete formula