ISEVEN function
TRUE if the number is even.
Information
Where can you use it?
Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.
Scenario in the workbook
Identify even batch numbers. Negative integers follow the same parity rule.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Input |
| 7 | 42 |
| 8 | 43 |
| 9 | -4 |
Record 1
=ISEVEN(A7)Expected resultTRUE
See the inputs and instructions for all 3 examplesCopyable formulas
English Excel · en-US
=ISEVEN(42)Turkish Excel · tr-TR
=ÇİFTMİ(42)Expected result
TRUE
Worked examples
Identify even batch numbers. Negative integers follow the same parity rule.
Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.
| Row | A |
|---|---|
| 6 | Input |
| 7 | 42 |
| 8 | 43 |
| 9 | -4 |
| Case | Formula | Expected result |
|---|---|---|
| Record 1 | =ISEVEN(A7) |
TRUE |
| Record 2 | =ISEVEN(A8) |
FALSE |
| Record 3 | =ISEVEN(A9) |
TRUE |