If we want to find if a value in a cell is even or odd, we can use the **excel ISEVEN function**. This function returns TRUE when the numeric value is even, and FALSE if it is odd. This post provides a clear guide on how to use the excel ISEVEN function to get even and odd numeric values in excel.

Figure 1: using ISEVEN function to check even numeric values

**Syntax of the formula**

**=ISEVEN (value)**

Where;

**Value**– is the numeric value we want to check

**Understanding the formula**

The ISEVEN function helps us to check if a numeric value is an even number. This formula returns **TRUE** if the numeric value is even, and **FALSE** if it is odd.

In figure 1 above, we have proceeded as follows;

- Get the numeric values in the excel spreadsheet
- In cell B2, we specify our formula, i.e.
`=ISEVEN (A2)`

- We then press Enter, to get the result.
- After we have the answer for cell B2, we copy the formula down to other cells to get the results.

Note that if a cell does not contain a numeric value, the ISEVEN function will return a **#VALUE error.**

**Instant Connection to an Expert through our Excelchat Service**

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

## Leave a Comment