Back to product guides

Google Sheets Formulas

In this article, you will learn how to round off decimal numbers in Google Sheets. More specifically, you will learn how to use ROUND, ROUNDUP, and ROUNDDOWN formulas in Google Sheets. These formulas are helpful when you don’t care about decimal numbers or when you calculate or seek for the number of something which should be an integer.

If you want to leave the first decimal place and round a number to the first decimal place, you don’t need to worry about it because these formulas also allow you to do so.

The “Round” formula helps you get rounded numbers quickly.

- Type in
**“=ROUND(”**or go to the**“Insert”**➝**“Function”**➝**“Math”**➝**“ROUND”**. - Then refer to a cell with the value you want to round or input the value manually for “Value” in the formula.
- Finally, input a number or refer to a cell containing a number to fill “places” in the formula. This number determines to which digit or decimal the formula rounds the value.

**Generic formula**

For example, let’s assume you want to round 12345.6789 to a certain decimal point. If you enter 1 as “place”, you get 12345.7. If you need an integer, you can fill “place” with 0, which lets the ROUND formula return 12345. The “value” and “place” numbers can be negative.

See the following screenshot for other examples.

You can take almost the same steps as the ones you take to round numbers. In this case, you use a slightly different formula, “ROUNDUP”.

- Type in
**“=ROUNDUP(”**or go to the**“Insert”**➝**“Function”**➝**“Math”**➝**“ROUNDUP”**. - Then refer to a cell with the value you want to round or input the value manually for “Value” in the formula.
- Finally, input a number or refer to a cell containing a number to fill “places” in the formula. This number determines to which digit or decimal the formula rounds
**up**the value.

**Generic formula**

You can see examples in the screenshot below to understand how that a “Place” number works in the formula.

Keep learning. The formula that enables you to round **down** numbers is “ROUNDDOWN”.

- Type in
**“=ROUNDDOWN(”**or go to the**“Insert”**➝**“Function”**➝**“Math”**➝**“ROUNDDOWN”**. - Then refer to a cell with the value you want to round or input the value manually for “Value” in the formula.
- Finally, input a number or refer to a cell containing a number to fill “places” in the formula. This number determines to which digit or decimal the function rounds
**down**the value.

**Generic formula**

Look at the examples below to see what rounded-down numbers look like with different “place” numbers.

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

If you don’t get the correct answer to your question in this article or have other questions related to cell formatting, you may find the answers in the following articles.

How to Show Gridlines in Google Sheets - show/delete gridlines

How to Add Borders in Google Sheets - add various types of cell borders

How to Color Cells in Google Sheets - fill in cells with color

How to Merge Cells in Google Sheets - combine cells

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Learn how to do this step-by-step in the video below 👇

Our team of real people are here to help you any time between 9am and 10pm GMT.

Email us at: founders@liveflow.io

Call us at +1 (415) 650-1711