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.

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

EVEN function in Excel, Positive Number

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

EVEN function, Negative Number

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

ODD function, Positive Number

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

ODD function, Negative Number

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

1. The ISEVEN function below returns TRUE.

ISEVEN, TRUE

2. The ISEVEN function below returns FALSE.

ISEVEN, FALSE

Add the IF function to return Even or Odd.

3. The formula below returns Even.

Even Number

4. The formula below returns Odd.

Odd Number

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

1. The ISODD function below returns TRUE.

ISODD, TRUE

2. The ISODD function below returns FALSE.

ISODD, FALSE

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

Odd Numbers

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

Excel