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 a simple formula to apply conditional formatting. Formulas allow you to make more powerful conditional formatting rules.
In this video, we look at how to use conditional formatting, with a formula, to shade every other row in a table. This is sometimes called "zebra striping", and it's a cool trick.
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows, and so on. This can be a nice way to make certain tables easier to read.
Related functions
Good links
