ISEVEN Function

Summary

ISEVEN returns TRUE when a number is even and FALSE when it is not. It is a small function, but it is handy in layouts, conditional formatting, and simple grouping rules.

One behavior matters more than anything else here: if you give it a decimal, Excel truncates the decimal part before checking. So 10.9 is treated as 10.

ISEVEN is simple, but it is useful in rules and grouping logic. It helps when the workbook needs to separate values by parity, such as alternating row patterns, batch checks, or formulas where even-numbered cases should behave differently from odd-numbered ones.

Syntax

=ISEVEN(number)

You can use a number, a formula, or a cell reference.

Arguments

• number - [required] The value you want to test for even parity.

ISEVEN vs Other Functions

Using ISEVEN

This function shows up a lot in formatting rules. A classic pattern is =ISEVEN(ROW()), which lets you shade even rows differently from odd ones.

It is also useful in simple splitting rules. If an ID, cycle number, or batch number should go down one path when it is even and another path when it is odd, ISEVEN keeps that logic easy to read.

Example 1 - Check even row numbers

This is the common zebra-striping pattern. When ROW() returns an even row number, ISEVEN returns TRUE, so the formula is often used in conditional formatting.

That makes the example practical right away. It is not just checking a number for fun, but helping the sheet format alternating rows more clearly.

=ISEVEN(ROW())

Example 2 - See the truncation rule

Decimals are truncated before the parity check happens. So 10.9 is treated as 10, which is why the result is TRUE.

This is one of the most important behavior details in the lesson because many users expect Excel to round instead. The example shows that it cuts off the decimal part first.

=ISEVEN(10.9) // Returns TRUE because Excel checks 10.

Example 3 - Check negative and zero values

Parity still works normally for zero and negative integers. A value like -2 is still even, so ISEVEN returns TRUE.

This helps make the rule feel simpler: the sign does not change whether a whole number is even or odd. Excel checks the integer value itself.

=ISEVEN(-2) // Returns TRUE.

Example 4 - Use it for grouping

This keeps a split rule readable. If the value in B1 is even, the formula sends it to Batch A. If it is odd, it goes to Batch B.

That makes the function useful beyond formatting. It can also drive small workflow splits when even-numbered items need one path and odd-numbered items need another.

=IF(ISEVEN(B1),"Batch A","Batch B")

Conclusion Recap

ISEVEN is a quick way to test whether a number lands on an even value. In this lesson, that included row logic, group splitting, decimals that get truncated, and negative numbers.

It is especially handy in alternating patterns, layout logic, and rules where even-number positions need to be handled differently.

• Main job: ISEVEN checks whether a number is even.
• Decimal rule: Excel truncates before checking.
• Good uses: Alternating rows, simple grouping, and cycle checks.
• Works with: Zero and negative even numbers too.