STATISTICS & DECISION RULES · ORIGINAL EXERCISE
Pack in sets of five
Round the score in B2 down to the nearest multiple of 5.
This quest practices FLOOR using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Learner | Score | Tier | Delivery | Pickup |
|---|---|---|---|---|
| Ari | 84 | Gold | true | false |
| Bea | 71 | Silver | false | false |
| Cam | 92 | Gold | false | true |
| Dev | 84 | Gold | true | true |
| Em | 63 | Bronze | true | false |
| Fox | 77 | Silver | false | true |
| Gia | 88 | Gold | false | false |
| Hal | 84 | Gold | true | false |
Hints to get you started
- FLOOR rounds to a multiple rather than decimal places.
- The multiple is 5.
- Use the score in B2 as the number.
Show the worked solution
=FLOOR(B2,5)For positive numbers, FLOOR moves down to a complete multiple. This pattern also works for pack sizes and pricing steps.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →