Basic Functions
Intermediate
CEILING and FLOOR Functions
Round numbers up or down to specific multiples.
Task:
You are setting prices and want to ensure they are rounded to the nearest $5 for simplicity. Round the original prices up to the nearest $5 in column B using CEILING and down to the nearest $5 in column C using FLOOR to create consistent and appealing price points.
Learning Objectives:
- Learn CEILING and FLOOR functions
- Understand rounding to multiples
- Practice pricing calculations
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 | Original Price | Ceiling ($5) | Floor ($5) |
| 2 | 23.45 | ||
| 3 | 47.89 | ||
| 4 | 31.12 | ||
| 5 | 56.78 |
What this exercise teaches (contains the answer)
CEILING and FLOOR functions are useful for rounding numbers to specific multiples, often used in pricing, scheduling, or resource allocation.