Fresh Excel Tips

In our previous articles, we went over standard functions for rounding up a number. In addition to those, there are other functions available like EVEN and ODD. For example, to round up a number to the nearest even integer, use the EVEN function. Here is the syntax that is used for both the even and odd functions:
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.

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 the following function: =ODD(A2).
5. Press Ctrl+Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. How to Use the ISODD and ROW functions to determine odd rows
2. Use the ISODD and COLUMN functions to determine odd columns
3. Use the ISEVEN and ISODD functions to check if a number is even or odd
4. How to Round Time to the nearest 15 minute in Excel
5. Use the FLOOR function to round down values to the nearest 100