Microsoft Excel Functions & Formulas

Use the EVEN and ODD functions to determine

the nearest even/odd value

In addition to the standard functions for rounding up a number,

there are other functions available like EVEN and ODD. For exam-

ple, to round up a number to the nearest even integer, use the

EVEN function.

EVEN(number)

number: The value to be rounded.

To round up a number to the nearest odd value, use the ODD

function.

ODD(number)

number: The value to be rounded.

4

To determine the nearest even/odd value:

1. In cells A2:A10 list some valid numbers with decimal

points.

2. Select cells B2:B10 and enter the following function:

=EVEN(A2).

3. Press <Ctrl+Enter>.

4. Select cells C2:C10 and enter ...