The ISEVEN function returns TRUE or FALSE: If cell A1 contains 11, the formula below returns FALSE: Only the integer portion of value is tested. If value is a decimal number, the decimal portion is truncated:


If value is not numeric, ISEVEN will return the #VALUE error. Only the integer portion of value is tested, decimal values are truncated. Use the ISODD function to test for odd numbers.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.