# How to use Even and Odd function in Excel

Oct 30, 2020 • edited Nov 01, 2020

This example illustrates the EVEN and the ODD function in Excel. It also shows you how to determine if a number is even or odd.

### Even

1. Rounds a positive number up to the nearest even integer.

2. Rounds a negative number down to the nearest even integer.

### Odd

1. Rounds a positive number up to the nearest odd integer.

2. Rounds a negative number down to the nearest odd integer.

### Even or Odd?

One way to determine if a number is even or odd is to use the MOD function. The MOD function gives the remainder of a division.

1. Even numbers divided by 2 always give a remainder of 0. For example, 28 is divided by 2 (exactly 14 times) to give a remainder of 0. As a result, the IF function returns Even.

2. Odd numbers divided by 2 always give a remainder of 1. For example, 29 is divided by 2 (14 times) to give a remainder of 1. As a result, the IF function returns Odd.

#Tutorial#How To#Functions#Round

How to Use Days until Birthday In Excel

How to Use Find function in Excel