Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ISEVEN
ISEVEN determines whether a number is even by checking that dividing it by 2 leaves no remainder; it truncates any decimal portion before evaluating. Common uses include alternating row shading, splitting lists into two groups, or validating ID numbering schemes.
Excel
=ISEVEN(A2)Google Sheets
=ISEVEN(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Number | IsEven? |
| 4 | TRUE |
| 7 | FALSE |
| 10 | TRUE |
=ISEVEN(A2)→TRUE
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Provide a number or cell reference (e.g., =ISEVEN(A2)); non-integers are truncated toward zero.
- 2The function returns TRUE for even numbers (0, 2, 4, …) and FALSE for odd numbers.
- 3Use with conditional formatting: apply a fill when ISEVEN(ROW()) is TRUE to shade alternate rows.
Need a version for your data?
Try: “Highlight every even-numbered row in my table using conditional formatting”