EVEN and ODD in Excel

Use EVEN and ODD in Excel to round numbers. Use ISEVEN or ISODD in Excel to determine if a number is even or odd.

EVEN function

The EVEN function rounds a positive number up to the nearest even integer.

The EVEN function rounds a negative number down to the nearest even integer.

ODD function

The ODD function rounds a positive number up to the nearest odd integer.

The ODD function rounds a negative number down to the nearest odd integer.

ISEVEN function

The ISEVEN function returns TRUE if a number is even and FALSE if a number is odd.

1. The ISEVEN function below returns TRUE.

2. The ISEVEN function below returns FALSE.

Add the IF function to return Even or Odd.

3. The formula below returns Even.

4. The formula below returns Odd.

ISODD function

The ISODD function returns TRUE if a number is odd and FALSE if a number is even.

1. The ISODD function below returns TRUE.

2. The ISODD function below returns FALSE.

3. Here's a cool example. Use conditional formatting and the ISODD function to highlight all odd numbers.

Note: instead of using ISEVEN or ISODD to determine if a number is even or odd, use the MOD function in Excel.

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.