Excel ISEVEN Function — How to Use It (with 3 Examples)

Contents

What does ISEVEN do?

ISEVEN returns TRUE if a number is even, and FALSE if it is odd. Decimal numbers are rounded down to a whole number before the check.

Common uses include alternating row formatting logic and any calculation that needs to treat odd and even cases differently.

=ISEVEN(number)

Argument	Description
number required	The number to test. Decimals are truncated first.

Example 1

Test a whole number

=ISEVEN(4)

Returns TRUE.

Example 2

Test an odd number

=ISEVEN(7)

Returns FALSE.

Example 3

Alternate logic based on row number

=IF(ISEVEN(ROW()),"Even row","Odd row")

Combines with ROW() to apply different logic depending on whether the current row number is even or odd.

⚠️ Forgetting decimals get truncated first

ISEVEN(4.9) checks 4, not 4.9, and returns TRUE — the decimal portion is simply dropped before testing.

Does ISEVEN work with negative numbers?

Yes — -4 is treated as even, -7 as odd, following the same logic as positive numbers.

ExcelPro has 700+ hands-on Excel exercises across 7 career tracks — free to start, no download needed.

ISODD MOD SIGN