Basic Functions
Intermediate
EVEN and ODD Functions
Round numbers to the nearest even or odd integer.
Task:
You are working on a project that requires rounding numbers to the nearest even or odd integer for specific calculations. Round the numbers to the nearest even integer in column B and the nearest odd integer in column C to meet these requirements.
Learning Objectives:
- Learn EVEN and ODD functions
- Understand specialized rounding
- Practice number manipulation
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Number | Even | Odd |
| 2 | 7.3 | ||
| 3 | 12.8 | ||
| 4 | 5.1 | ||
| 5 | 18.9 |
What this exercise teaches (contains the answer)
EVEN and ODD functions are useful for specific rounding requirements where results must be even or odd integers.