ISEVEN function
Quick answer
ISEVEN returns TRUE when a number is even.
- Syntax
=ISEVEN(number)- Most common use
=IF(ISEVEN(A2),"North side","South side")returns North side (214 is even, so it's on the north side)
It answers practical either-or questions: which side of the street a house is on, which shift an employee works, or which rows to shade. Decimals are dropped before the test, so 4.7 counts as 4.
- Available in
- Every current version
- Category
- Information functions
- Returns
- TRUE if the number is even, FALSE if it is odd. #VALUE! for text.
- Google Sheets
- Available in Google Sheets with the same argument.
Syntax
=ISEVEN(number)
| Argument | Required? | What it is |
|---|---|---|
number | Required | The number to test. Decimals are truncated, so 4.7 counts as 4. |
Examples
Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.
| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | =IF(ISEVEN(A2),"North side","South side") | North side | 214 is even, so it's on the north side |
| E2 | =SUMPRODUCT(--(MOD(A2:A6,2)=0)) | 3 | ISEVEN takes one value at a time, so count a range with MOD |
| F2 | =ISEVEN(4.7) | TRUE | TRUE: the decimal is dropped, leaving 4 |
Try it live
This is the sample sheet. Change any number or text, or edit a formula, and the results update.
Show the sample data as a table
| House no. | Street | Row 2 side | Even house numbers | Is 4.7 even? | |
| 214 | Elm St | North side | 3 | TRUE | |
| 215 | Elm St | ||||
| 302 | Oak Ave | ||||
| 317 | Oak Ave | ||||
| 400 | Pine Rd |
Practice ISEVEN
Graded instantly, then re-checked on changed data.
Day or night shift
C2, return Day if the employee ID in A2 is even, otherwise Night. Fill down to C7.Common mistakes
| What you see | Why, and how to fix it |
|---|---|
| #VALUE! | The cell holds text, such as "Unit 4". Pull the number out first, or test only cells where ISNUMBER is TRUE. |
| Blank cells count as even | An empty cell is treated as 0, and 0 is even. Check ISBLANK first if blanks are possible. |
| #VALUE! for a whole range | ISEVEN is built for single values. To count even numbers in a range, use =SUMPRODUCT(--(MOD(A2:A6,2)=0)). |
Tips
- Shade every other row with a conditional formatting rule of =ISEVEN(ROW()).
Questions
How do I check if a number is even in Excel?
=ISEVEN(A2) returns TRUE for even numbers. =MOD(A2,2)=0 is the same test for whole numbers.
How do I shade every other row?
Use conditional formatting with the formula =ISEVEN(ROW()). It keeps working when you sort or insert rows.
Answers that use ISEVEN
In other languages
ISEVEN is ES.PAR in Spanish Excel and ISTGERADE in German Excel. Each page has the syntax with semicolons, the examples and the exercise in that language. For other functions and languages, use the Function Translator.
Updated Checked by running: every formula on this page was run by our formula engine on .