# ISEVEN function in Excel

> ISEVEN returns TRUE when a number is even.

Source: https://spreadsheetpractice.com/functions/iseven · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** 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)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **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.

## What it does

ISEVEN returns TRUE when a number is even. 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.

## 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 was calculated by running the formula on the sample sheet.

| 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 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | House no. | Street |  | Row 2 side | Even house numbers | Is 4.7 even? |
| 2 | 214 | Elm St |  | North side | 3 | TRUE |
| 3 | 215 | Elm St |  |  |  |  |
| 4 | 302 | Oak Ave |  |  |  |  |
| 5 | 317 | Oak Ave |  |  |  |  |
| 6 | 400 | Pine Rd |  |  |  |  |

## 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()).

## Related functions

- [ISODD](https://spreadsheetpractice.com/functions/isodd): ISODD returns TRUE when a number is odd.
- [MOD](https://spreadsheetpractice.com/functions/mod): MOD returns the remainder after dividing one number by another.
- [ROW](https://spreadsheetpractice.com/functions/row): ROW returns the row number of a cell: ROW(C7) is 7, and ROW() with nothing inside returns the row of the cell the formula sits in.

## 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.

## Practice

A graded ISEVEN exercise ("Day or night shift") is on [the ISEVEN page](https://spreadsheetpractice.com/functions/iseven). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
