ISEVEN Function in Excel: Is the Number Even?

📎 This article includes 1 downloadable practice file ↓

InformationLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. ISEVEN in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

ISEVEN returns TRUE for even numbers; ISODD for odd ones. Decimals are truncated first.

Syntax

=ISEVEN(number)

Argument	What it means
number	A number.

Examples

Example 1

=ISEVEN(ROW())

Shade every other row.

Example 2

=IF(ISODD(MID(A2,17,1)), "Male", "Female")

Example of a code where the odd/even digit carries meaning.

ISEVEN in practice

Where you will use it

• Alternate row shading with ROW()
• Split items into two teams
• Check pairs and even quantities

Worked example

Number	Formula	Result
4	=ISEVEN(A2)	TRUE
7	=ISEVEN(A3)	FALSE
0	=ISEVEN(A4)	TRUE

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Decimals	ISEVEN ignores decimals: 4.9 counts as 4
Text numbers	Convert with VALUE

Related functions

ISODD · MOD

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Information guides →

ISOMITTED Function in Excel: Was an Optional Argument Left Out?LogicalLevel: ExpertAvailable in: Excel 365 / 2021+ISOMITTED is used inside LAMBDA to give optional…N Function in Excel: Turn a Value Into a NumberN returns numbers unchanged, TRUE as 1 and text as 0. Its oddest use…ISNONTEXT Function in Excel: Anything But TextISNONTEXT is TRUE for numbers, blanks, errors and logicals. Handy in data validation to…TYPE Function in Excel: What Kind of Value Is This?InformationLevel: IntermediateAvailable in: Excel 2007+TYPE returns 1 number, 2 text, 4 logical, 16 error…

📎 Practice files for this article

• 📗
  Practice workbook: Information (IS…) functions15 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 34 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.