Even and Odd

 

Even | Odd | Even or Odd?

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.

Even Function in Excel, Positive Number

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

Even Function, Negative Number

Odd

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

Odd Function, Positive Number

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

Odd Function, Negative Number

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.

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.

Odd

Do you like this free website? Please follow us on Google+