Conditional Logic

Excel formula for Check if a number is even or odd

Label numbers as even or odd, or flag every other row.

Copy this formula

=IF(ISEVEN(A2), "Even", "Odd")

How the formula works

ISEVEN returns TRUE for even numbers and ISODD for odd ones. Applied to the row number, they're a quick way to alternate-stripe or split data into two groups.

Examples

=IF(MOD(A2, 2)=0, "Even", "Odd")→Odd

MOD by 2 also tests parity.

FAQ

How do I shade every other row?

Use conditional formatting with the rule =ISEVEN(ROW()).

Related formulas

Get the remainder or whole number IF with AND / OR conditions

Functions used

ISEVEN ISODD MOD

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free