Excel ISEVEN Function
Summary
The Excel ISEVEN function returns TRUE when a numeric value is even, and FALSE for odd numbers. ISEVEN will return the #VALUE error when a value is not numeric.
Purpose
Test if a value is even
Return value
A logical value (TRUE or FALSE)
Syntax
=ISEVEN (value)
Arguments
- value - The numeric value to check.
Usage notes
Use the ISEVEN function to check if a numeric value is an even number. ISEVEN will return TRUE when a numeric value is even and FALSE when a numeric value is odd. If value is not numeric, ISEVEN will return the #VALUE error.
For example, =ISEVEN(A1) will return TRUE if A1 contains the number 2 and FALSE if A1 contains the number 3.
Usually, value is supplied as a cell address.
ISEVEN is part of a group of functions called the IS functions that all return the logical values TRUE or FALSE.
ISEVEN formula examples
If you want to highlight every other row in a table (sometimes called zebra striping) with conditional formatting you can do so with a simple formula that uses either the ISEVEN or ISODD function. For example, if you...
To highlight rows in groups of "n" (i.e. shade every 3 rows, every 5 rows, etc.) you can apply conditional formatting with a formula based on the ROW, CEILING and ISEVEN functions.
In the example shown, the formula...
Related videos
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows - groups of 3 rows, groups of 4 rows, and so on.
In this video, we'll look at how to use a simple formula to apply conditional formatting. Formulas allow you to create more flexible and powerful conditional formats.
In this video, we'll look at how to use conditional formatting to shade every other row in a table. This is sometimes called "zebra striping".
Related functions
Good links
