---
title: "ROUND function in Excel: syntax and examples | ExcelSavvy"
description: "How to use ROUND in Excel and Google Sheets: round to decimals, whole numbers or hundreds. Examples and a live drill."
canonical_url: "https://excelsavvy.com/functions/round"
meta:
  "og:description": "How to use ROUND in Excel and Google Sheets: round to decimals, whole numbers or hundreds. Examples and a live drill."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBST1VORCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogcm91bmQgdG8gZGVjaW1hbHMsIHdob2xlIG51bWJlcnMgb3IgaHVuZHJlZHMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Uk9VTkQobnVtYmVyLCBudW1fZGlnaXRzKQ%2Cp_Ii9mdW5jdGlvbnMvcm91bmQi%2Cs_Ab4NPIBDe3v8H1aL.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "ROUND function in Excel: syntax and examples | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBST1VORCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogcm91bmQgdG8gZGVjaW1hbHMsIHdob2xlIG51bWJlcnMgb3IgaHVuZHJlZHMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Uk9VTkQobnVtYmVyLCBudW1fZGlnaXRzKQ%2Cp_Ii9mdW5jdGlvbnMvcm91bmQi%2Cs_Ab4NPIBDe3v8H1aL.png"
---

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

# **The ROUND function**

Rounds a number to a given number of decimals. Halves round away from zero; negative decimals round to tens, hundreds and so on.

=

ROUND(

## **How to use ROUND**

ROUND changes a number itself so it has fewer decimals, like rounding a price to the nearest cent. The second argument says how many decimals to keep: 2 for hundredths, 0 for a whole number, and a negative number to round to tens or hundreds.

Use it when the rounded value is the one you actually bill or report: VAT on an invoice line, hourly rate times hours, a percentage share of a budget. `**=ROUND(3.14159,2)**` gives 3.14, and `**=ROUND(1250,-2)**` rounds to the nearest hundred and gives 1300. A value exactly halfway rounds away from zero, so 2.5 becomes 3 and -2.5 becomes -3.

Do not confuse ROUND with cell formatting. Formatting only changes what you see, while the cell still holds every decimal. A total of formatted cells can then look off by a cent. ROUND changes the value, so the total matches the numbers on screen.

When you must always go up or always go down, such as boxes needed for an order or full teams, use ROUNDUP or ROUNDDOWN. ROUND picks the nearest number, which can leave you one short.

## **Syntax**

```
ROUND(number, num_digits)
```

<dl><dt>**number **</dt>
<dd>The number to round.</dd>
<dt>**num_digits **</dt>
<dd>Decimals to keep: 2 for hundredths, 0 for whole numbers, -2 for hundreds.</dd></dl>

## **Examples**

B1`=ROUND(<sup>1</sup>3.14159,<sup>2</sup>2)`

|  | A | B |
| --- | --- | --- |
| 1 |  | **3.14** |

**In plain words:** Round <sup>1</sup>3.14159 to <sup>2</sup>2 decimal places.

B1=ROUND(1250,-2)

|  | A | B |
| --- | --- | --- |
| 1 |  | **1300** |

## **Common ROUND mistakes**

- My total is off by a cent, but every line looks right

  The lines are only formatted to two decimals, so the hidden decimals still add up. Wrap each line in ROUND, like `**=ROUND(B2*C2,2)**`, and then add up the rounded lines.
- ROUND did not round to hundreds

  A positive second argument rounds to the right of the decimal point. For hundreds, use a negative number: `**=ROUND(1250,-2)**`. Use -1 for tens and -3 for thousands.
- ROUND gave me too few boxes, seats or teams

  ROUND goes to the nearest whole number, so 5.4 becomes 5 and the last items have no room. Use `**=ROUNDUP(B2,0)**` when anything left over still needs a whole unit.
- ROUND returns #VALUE!

  The first argument is text, for example a number stored as text or a cell with a unit like "12 kr". Clean it with `**=VALUE(A2)**` or remove the unit, then round.

## **Practice ROUND**

- [**1****Round a price to two decimals**→](https://excelsavvy.com/practice/round/round-two-decimals)
- [**2****Round to the nearest hundred**→](https://excelsavvy.com/practice/round/round-nearest-hundred)
- [**3****Round an average with ROUND**→](https://excelsavvy.com/practice/average/round-an-average)

## **Read the guide**

- [**Excel for finance and accounting: the skills you actually use**](https://excelsavvy.com/learn/excel-for-finance)
- [**How to calculate percentages in Excel: percent of a number, change, discount and VAT**](https://excelsavvy.com/learn/calculate-percentage-excel)
- [**Excel practice data: free datasets with tasks and answers**](https://excelsavvy.com/learn/excel-practice-data)
- [**Excel finance data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-finance-practice-data)

## **Questions**

<details>

<summary>

### Does formatting a cell round the number?

</summary>

No. A number format only changes what you see; the cell still holds every decimal. ROUND changes the value itself.

</details>

<details>

<summary>

### How do I round to the nearest whole number?

</summary>

Use 0 as the second argument: =ROUND(A2,0). 7.5 rounds up to 8 and 7.4 rounds down to 7.

</details>

<details>

<summary>

### How do I round to the nearest 5 or 0.5?

</summary>

Use MROUND, which rounds to a multiple: =MROUND(A2,5) rounds to the nearest 5 and =MROUND(A2,0.5) rounds to the nearest half.

</details>

<details>

<summary>

### How do I always round up or down?

</summary>

Use ROUNDUP to always go up and ROUNDDOWN to always go down, with the same two arguments as ROUND: =ROUNDUP(A2,0) and =ROUNDDOWN(A2,0).

</details>

## **Related functions**

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

```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/functions/round#webpage","dateModified":"2026-11-16","description":"How to use ROUND in Excel and Google Sheets: round to decimals, whole numbers or hundreds. Examples and a live drill.","name":"ROUND function in Excel: syntax and examples","url":"https://excelsavvy.com/functions/round","@type":["WebPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/functions/round#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/functions/round#/schema/question/1"},{"@id":"https://excelsavvy.com/functions/round#/schema/question/2"},{"@id":"https://excelsavvy.com/functions/round#/schema/question/3"},{"@id":"https://excelsavvy.com/functions/round#/schema/question/4"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/functions/round"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/functions/round#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel functions","item":"https://excelsavvy.com/functions","position":2},{"@type":"ListItem","name":"ROUND function in Excel: syntax and examples","position":3}]},{"@id":"https://excelsavvy.com/functions/round#article","dateModified":"2026-11-16","description":"How to use ROUND in Excel and Google Sheets: round to decimals, whole numbers or hundreds. Examples and a live drill.","headline":"ROUND function in Excel: syntax and examples","inLanguage":"en-US","thumbnailUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBST1VORCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogcm91bmQgdG8gZGVjaW1hbHMsIHdob2xlIG51bWJlcnMgb3IgaHVuZHJlZHMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Uk9VTkQobnVtYmVyLCBudW1fZGlnaXRzKQ%2Cp_Ii9mdW5jdGlvbnMvcm91bmQi%2Cs_Ab4NPIBDe3v8H1aL.png","@type":["Article","TechArticle"],"author":{"@id":"https://excelsavvy.com/#identity"},"image":{"@id":"https://excelsavvy.com/#/schema/image/1"},"isPartOf":{"@id":"https://excelsavvy.com/functions/round#webpage"},"mainEntityOfPage":{"@id":"https://excelsavvy.com/functions/round#webpage"},"publisher":{"@id":"https://excelsavvy.com/#identity"}},{"@id":"https://excelsavvy.com/functions/round#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"Does formatting a cell round the number?","acceptedAnswer":{"@type":"Answer","text":"No. A number format only changes what you see; the cell still holds every decimal. ROUND changes the value itself."}},{"@id":"https://excelsavvy.com/functions/round#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I round to the nearest whole number?","acceptedAnswer":{"@type":"Answer","text":"Use 0 as the second argument: =ROUND(A2,0). 7.5 rounds up to 8 and 7.4 rounds down to 7."}},{"@id":"https://excelsavvy.com/functions/round#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I round to the nearest 5 or 0.5?","acceptedAnswer":{"@type":"Answer","text":"Use MROUND, which rounds to a multiple: =MROUND(A2,5) rounds to the nearest 5 and =MROUND(A2,0.5) rounds to the nearest half."}},{"@id":"https://excelsavvy.com/functions/round#/schema/question/4","@type":"Question","inLanguage":"en-US","name":"How do I always round up or down?","acceptedAnswer":{"@type":"Answer","text":"Use ROUNDUP to always go up and ROUNDDOWN to always go down, with the same two arguments as ROUND: =ROUNDUP(A2,0) and =ROUNDDOWN(A2,0)."}},{"@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"},{"@id":"https://excelsavvy.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBST1VORCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogcm91bmQgdG8gZGVjaW1hbHMsIHdob2xlIG51bWJlcnMgb3IgaHVuZHJlZHMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Uk9VTkQobnVtYmVyLCBudW1fZGlnaXRzKQ%2Cp_Ii9mdW5jdGlvbnMvcm91bmQi%2Cs_Ab4NPIBDe3v8H1aL.png","inLanguage":"en-US","url":"https://excelsavvy.com/_og/d/c_Page%2Ctitle_~Uk9VTkQgZnVuY3Rpb24gaW4gRXhjZWw6IHN5bnRheCBhbmQgZXhhbXBsZXM%2Cdescription_~SG93IHRvIHVzZSBST1VORCBpbiBFeGNlbCBhbmQgR29vZ2xlIFNoZWV0czogcm91bmQgdG8gZGVjaW1hbHMsIHdob2xlIG51bWJlcnMgb3IgaHVuZHJlZHMuIEV4YW1wbGVzIGFuZCBhIGxpdmUgZHJpbGwu%2Ceyebrow_Excel%2Bfunctions%2Csite_practiceexcel%2Ccode_~Uk9VTkQobnVtYmVyLCBudW1fZGlnaXRzKQ%2Cp_Ii9mdW5jdGlvbnMvcm91bmQi%2Cs_Ab4NPIBDe3v8H1aL.png"}]}
```

## Sitemap

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