---
title: "ROUND, ROUNDUP and ROUNDDOWN practice: 4 exercises with answers"
description: "Practice ROUND, ROUNDUP and ROUNDDOWN in Excel: round a price, round to the nearest hundred and count whole teams, checked in a live spreadsheet."
canonical_url: "https://excelsavvy.com/practice/round"
meta:
  "og:description": "Practice ROUND, ROUNDUP and ROUNDDOWN in Excel: round a price, round to the nearest hundred and count whole teams, checked in a live spreadsheet."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQsIFJPVU5EVVAgYW5kIFJPVU5ERE9XTiBwcmFjdGljZTogNCBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgUk9VTkQsIFJPVU5EVVAgYW5kIFJPVU5ERE9XTiBpbiBFeGNlbDogcm91bmQgYSBwcmljZSwgcm91bmQgdG8gdGhlIG5lYXJlc3QgaHVuZHJlZCBhbmQgY291bnQgd2hvbGUgdGVhbXMsIGNoZWNrZWQgaW4gYSBsaXZlIHNwcmVhZHNoZWV0Lg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkl0ZW0iLCJQcmljZSIsIldpdGggMjUlIFZBVCJdfSx7Im4iOjIsImNlbGxzIjpbIkhlYWRwaG9uZXMiLCI3OS45OSIsIiJdfV0sInRhcmdldCI6WzEsMl19fQ%2Cp_Ii9wcmFjdGljZS9yb3VuZCI%2Cs_wEumraVks3NapTva.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "ROUND, ROUNDUP and ROUNDDOWN practice: 4 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQsIFJPVU5EVVAgYW5kIFJPVU5ERE9XTiBwcmFjdGljZTogNCBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgUk9VTkQsIFJPVU5EVVAgYW5kIFJPVU5ERE9XTiBpbiBFeGNlbDogcm91bmQgYSBwcmljZSwgcm91bmQgdG8gdGhlIG5lYXJlc3QgaHVuZHJlZCBhbmQgY291bnQgd2hvbGUgdGVhbXMsIGNoZWNrZWQgaW4gYSBsaXZlIHNwcmVhZHNoZWV0Lg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIl0sInJvd3MiOlt7Im4iOjEsImNlbGxzIjpbIkl0ZW0iLCJQcmljZSIsIldpdGggMjUlIFZBVCJdfSx7Im4iOjIsImNlbGxzIjpbIkhlYWRwaG9uZXMiLCI3OS45OSIsIiJdfV0sInRhcmdldCI6WzEsMl19fQ%2Cp_Ii9wcmFjdGljZS9yb3VuZCI%2Cs_wEumraVks3NapTva.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **ROUND, ROUNDUP and ROUNDDOWN practice exercises**

Round numbers to a number of decimals, or to the nearest ten or hundred, and always up or down when the task needs it.

[**Start the first exercise**](https://excelsavvy.com/practice/round/round-two-decimals)

ROUND(ROUNDDOWN(ROUNDUP(

## **How ROUND, ROUNDUP and ROUNDDOWN work**

ROUND, ROUNDUP and ROUNDDOWN all take two arguments: the number and how many decimals to keep. ROUND goes to the nearest value, ROUNDUP always moves away from zero, and ROUNDDOWN always moves toward zero. A negative number of decimals rounds to the left of the decimal point.

`**=ROUND(B2*1.25,2)**` adds 25% VAT to the price in B2 and keeps two decimals, so 19.99 becomes 24.99. `**=ROUNDUP(A2/B2,0)**` works out how many boxes you need: 25 items at 10 per box is 2.5, and it rounds up to 3. `**=ROUND(B2,-2)**` rounds 1,284 visitors to 1,300. `**=ROUNDDOWN(A2/B2,0)**` gives the number of full teams you can make.

The classic pitfall is a number format. Showing two decimals only changes how the cell looks, and later formulas still use the full value, so a column of rounded-looking prices can add up to something that seems off by a cent. Wrap the calculation in ROUND when the rounded value is what you want to work with. The exercises below cover a price, boxes, the nearest hundred and whole teams.

1. [**1****Round a price to two decimals**In C2, add 25% VAT to the price in B2 (multiply by 1.25) and use ROUND to round the result to 2 decimals.](https://excelsavvy.com/practice/round/round-two-decimals)
2. [**2****Always round up with ROUNDUP****Premium**In C2, work out how many boxes are needed for the items in A2 when each box holds B2. A part-full box is still a box, so use ROUNDUP with 0 decimals.](https://excelsavvy.com/practice/round/roundup-boxes-needed)
3. [**3****Round to the nearest hundred****Premium**In C2, use ROUND to round the visitor count in B2 to the nearest hundred. A negative number of decimals rounds to the left of the decimal point.](https://excelsavvy.com/practice/round/round-nearest-hundred)
4. [**4****Count only whole teams with ROUNDDOWN****Premium**In C2, work out how many full teams of B2 people you can make from the A2 people who signed up. A team that isn't full doesn't count, so use ROUNDDOWN with 0 decimals.](https://excelsavvy.com/practice/round/rounddown-full-teams)

## **Functions in this topic**

- [**ROUND**](https://excelsavvy.com/functions/round)
- [**ROUNDDOWN**](https://excelsavvy.com/functions/rounddown)
- [**ROUNDUP**](https://excelsavvy.com/functions/roundup)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**Excel for finance and accounting: the skills you actually use**](https://excelsavvy.com/learn/excel-for-finance)
- [**Excel practice data: free datasets with tasks and answers**](https://excelsavvy.com/learn/excel-practice-data)

## **Questions**

<details>

<summary>

### How do I round to the nearest 5 in Excel?

</summary>

Divide by 5, round, and multiply by 5 again: =ROUND(B2/5,0)\*5 turns 23 into 25 and 22 into 20. The same trick works for any step. For the nearest 0.5, use =ROUND(B2/0.5,0)\*0.5. For the nearest 10 or 100, a negative number of decimals is simpler.

</details>

<details>

<summary>

### Why does my total look off when the numbers are rounded?

</summary>

Because a number format only changes what you see, not the value Excel stores. The total adds the unrounded numbers behind the cells. To make the total match what is on screen, round inside the formula with ROUND instead of formatting the cells.

</details>

<details>

<summary>

### What is the difference between ROUNDDOWN and INT?

</summary>

They give the same result for positive numbers, but not for negative ones. ROUNDDOWN cuts off the decimals toward zero, so ROUNDDOWN(-2.5,0) is -2. INT always goes to the next lower whole number, so INT(-2.5) is -3. Use ROUNDDOWN when you need to keep a number of decimals as well.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/round#webpage","description":"Practice ROUND, ROUNDUP and ROUNDDOWN in Excel: round a price, round to the nearest hundred and count whole teams, checked in a live spreadsheet.","name":"ROUND, ROUNDUP and ROUNDDOWN practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/round","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/round#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/round#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/round#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/round#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/round"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/round#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"ROUND, ROUNDUP and ROUNDDOWN practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/round#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I round to the nearest 5 in Excel?","acceptedAnswer":{"@type":"Answer","text":"Divide by 5, round, and multiply by 5 again: =ROUND(B2/5,0)*5 turns 23 into 25 and 22 into 20. The same trick works for any step. For the nearest 0.5, use =ROUND(B2/0.5,0)*0.5. For the nearest 10 or 100, a negative number of decimals is simpler."}},{"@id":"https://excelsavvy.com/practice/round#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does my total look off when the numbers are rounded?","acceptedAnswer":{"@type":"Answer","text":"Because a number format only changes what you see, not the value Excel stores. The total adds the unrounded numbers behind the cells. To make the total match what is on screen, round inside the formula with ROUND instead of formatting the cells."}},{"@id":"https://excelsavvy.com/practice/round#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"What is the difference between ROUNDDOWN and INT?","acceptedAnswer":{"@type":"Answer","text":"They give the same result for positive numbers, but not for negative ones. ROUNDDOWN cuts off the decimals toward zero, so ROUNDDOWN(-2.5,0) is -2. INT always goes to the next lower whole number, so INT(-2.5) is -3. Use ROUNDDOWN when you need to keep a number of decimals as well."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
