Does ISEVEN work with negative numbers?

Yes. ISEVEN(-16) returns TRUE because -16 is an even number (divisible by 2). ISEVEN(-15) returns FALSE. Parity rules apply to negative integers identically to positive ones.

What happens if I pass a decimal to ISEVEN?

ISEVEN truncates the decimal to an integer before checking parity. ISEVEN(42.7) returns TRUE (42 is even), and ISEVEN(35.1) returns FALSE (35 is odd). The decimal portion is discarded without rounding.

Can I use ISEVEN to filter rows where hours are even?

Most modern spreadsheets support FILTER with ISEVEN: =FILTER(A2:E6, ISEVEN(E2:E6)) returns all rows where Hours Logged is even. Older spreadsheet versions require a helper column combined with AutoFilter.

When should I use ISEVEN instead of checking divisibility with MOD?

ISEVEN is purpose-built and more readable than =MOD(E2,2)=0, though both produce the same result. Prefer ISEVEN in spreadsheet formulas for clarity; it's also slightly faster and fewer characters to type.

ISEVEN function

ISEVEN returns TRUE if a number is even, FALSE if odd, making it useful for identifying parity in datasets for grouping or filtering.

=ISEVEN(number)

Generate a ISEVEN formula

Describe what you need. The generator will reach for ISEVEN where ISEVEN is the right tool, and tell you when it is not.

Arguments

How ISEVEN reads its arguments

Argument	Required	Description
number	Required	Any numeric value or cell reference; if text is provided, ISEVEN attempts to convert it to a number and returns an error if conversion fails.

Returns

Boolean: TRUE for even numbers, FALSE for odd numbers.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Identify tasks with even hours logged

Task	Owner	Start Date	Due Date	Hours Logged
Bug Fix Auth	Sarah Chen	2026-09-01	2026-09-03	16
UI Redesign	Marcus Lee	2026-09-02	2026-09-10	42
Database Migration	Priya Patel	2026-09-05	2026-09-08	28
API Documentation	Tom Wilson	2026-09-01	2026-09-07	14
Testing Suite	Alice Brown	2026-09-03	2026-09-12	35

=ISEVEN(E2)

Result: TRUE

The Hours Logged value in row 2 (Bug Fix Auth) is 16, which is an even number. ISEVEN(16) returns TRUE. This is useful for QA teams identifying tasks that consumed an exact number of half-days or validating that time allocations align with sprint planning assumptions.

2. Flag tasks needing re-estimation

Task	Owner	Start Date	Due Date	Hours Logged
Bug Fix Auth	Sarah Chen	2026-09-01	2026-09-03	16
UI Redesign	Marcus Lee	2026-09-02	2026-09-10	42
Database Migration	Priya Patel	2026-09-05	2026-09-08	28
API Documentation	Tom Wilson	2026-09-01	2026-09-07	14
Testing Suite	Alice Brown	2026-09-03	2026-09-12	35

=IF(ISEVEN(E3),"Even hours","Odd hours - review estimate")

Result: Even hours

Row 3 (UI Redesign) has 42 hours, an even number, so ISEVEN returns TRUE and the IF function displays "Even hours". Odd-hour totals like row 5's 35 hours would trigger a review, helping project managers spot unusual time allocations that warrant investigation or re-estimation.

3. Count how many tasks consumed even hours

Task	Owner	Start Date	Due Date	Hours Logged
Bug Fix Auth	Sarah Chen	2026-09-01	2026-09-03	16
UI Redesign	Marcus Lee	2026-09-02	2026-09-10	42
Database Migration	Priya Patel	2026-09-05	2026-09-08	28
API Documentation	Tom Wilson	2026-09-01	2026-09-07	14
Testing Suite	Alice Brown	2026-09-03	2026-09-12	35

=SUMPRODUCT(ISEVEN(E2:E6)*1)

Result: 4

Four tasks have even hours: 16, 42, 28, and 14. The fifth task (35 hours) is odd. SUMPRODUCT evaluates ISEVEN for each cell in the range, converts TRUE to 1 and FALSE to 0, then sums the results. This pattern helps forecast and track effort distribution across sprints.

Common errors

Which ISEVEN error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	The argument is a cell containing text that cannot be converted to a number, such as =ISEVEN(A2) where A2 contains a task name like "Bug Fix Auth", or =ISEVEN("pending") with literal text.	Ensure the argument references a numeric column (like Hours Logged). Validate the column first with =ISNUMBER(E2) if the data source is inconsistent, or add error handling with IFERROR.
#REF!	The argument references a cell or range that no longer exists, such as =ISEVEN(F2) after column F (Hours Logged) was deleted or moved to a different sheet without updating the formula.	Correct the cell reference to point to the current location of the Hours Logged data. Use Undo (Ctrl+Z) if deletion was accidental, or re-enter the formula with the correct range.
#NAME?	The function name is misspelled or unrecognized, such as =ISVEVEN(E2) or =IS_EVEN(E2), preventing the spreadsheet from parsing the function.	Correct the spelling to exactly =ISEVEN(). Most spreadsheet editors provide autocomplete suggestions; use them to avoid typos and ensure the formula is recognized.

Tips and when to use something else

ISEVEN works on integers and decimals—decimals are truncated before checking parity, so ISEVEN(3.9) returns FALSE (3 is odd), not TRUE based on rounding.
Pair ISEVEN with IF or IFS for conditional logic, or with SUMPRODUCT to aggregate rows by parity; this avoids adding helper columns to your timesheet.
Use ISODD for the inverse check; if you need to identify odd-hour tasks instead of even, =ISODD(hours) is clearer than =NOT(ISEVEN(hours)).
For dashboard visualization, combine ISEVEN with conditional formatting to highlight even-hour rows in green without needing extra columns or formulas.

Related functions

ISODDISODD returns TRUE if a number is odd, FALSE if even—use it to filter, validate, or categorize numeric data by parity for analysis and reporting.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.ISNUMBERChecks whether a value is a number, returning TRUE for numeric values and FALSE for text, dates, blanks, and errors.SUMPRODUCTSUMPRODUCT multiplies arrays element-by-element and sums the results, useful for weighted totals and multi-criteria counting.FILTERReturns filtered rows from an array based on a boolean criteria array, retaining the original order and all columns.

Frequently asked questions

Does ISEVEN work with negative numbers?: Yes. ISEVEN(-16) returns TRUE because -16 is an even number (divisible by 2). ISEVEN(-15) returns FALSE. Parity rules apply to negative integers identically to positive ones.
What happens if I pass a decimal to ISEVEN?: ISEVEN truncates the decimal to an integer before checking parity. ISEVEN(42.7) returns TRUE (42 is even), and ISEVEN(35.1) returns FALSE (35 is odd). The decimal portion is discarded without rounding.
Can I use ISEVEN to filter rows where hours are even?: Most modern spreadsheets support FILTER with ISEVEN: =FILTER(A2:E6, ISEVEN(E2:E6)) returns all rows where Hours Logged is even. Older spreadsheet versions require a helper column combined with AutoFilter.
When should I use ISEVEN instead of checking divisibility with MOD?: ISEVEN is purpose-built and more readable than =MOD(E2,2)=0, though both produce the same result. Prefer ISEVEN in spreadsheet formulas for clarity; it's also slightly faster and fewer characters to type.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17