Excel / Round to Even or Odd Integers with EVEN and ODD
In Excel, EVEN returns an even integer and ODD returns an odd integer. If the input is already an integer of the requested kind, it stays the same. Otherwise, the function moves away from zero just far enough to find one. For example, EVEN(3) gives 4 and EVEN(-3) gives -4.
EVEN and ODD syntax
Each function takes one number. Type it directly or refer to a cell with a number, such as A2 below. EVEN(4) stays 4 and ODD(-5) stays -5.
=EVEN(A2)
=ODD(A2)
Microsoft’s EVEN function reference
Microsoft’s ODD function reference
Results for positive numbers, negatives, decimals, and zero
Enter the inputs starting at A2. In B2 use the EVEN formula and in C2 use the ODD formula, then fill down.
| Input | EVEN | ODD |
|---|---|---|
| 122.1 | 124 | 123 |
| -122.1 | -124 | -123 |
| 0 | 0 | 1 |
| 4 | 4 | 5 |
| -5 | -6 | -5 |
| -0.1 | -2 | -1 |
For 122.1, the results are 124 and 123. For -122.1, both results are more negative than the input. The same rule applies to a small negative such as -0.1. Zero is already even, so EVEN(0) is 0 and ODD(0) is 1.
Calculate a quantity sold in pairs
If you need 17 parts and they come only in packs of two, use EVEN to calculate the quantity to order. The result is 18 parts, or nine packs.
=EVEN(17)
This example uses nonnegative quantities. Divide the rounded quantity by two to get the pack count. For packs of five or ten, use a function that rounds to a multiple of that pack size.
How EVEN and ODD differ from ISEVEN and ISODD
EVEN and ODD return numbers. To test whether a value is even or odd, use ISEVEN or ISODD, which return logical values. For example, EVEN(3) gives 4 and ISEVEN(3) gives FALSE.




