How to Round Up on Google Sheets on PC or Mac

Co-authored by wikiHow Staff

Last Updated: May 15, 2018

This wikiHow teaches you how to pull numeric data from a cell on a Google Sheets spreadsheet, and round it up to any number of decimal places, using a desktop internet browser.

Steps

1
Open Google Sheets in your internet browser. Type sheets.google.com into your browser's address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
2
Click the spreadsheet you want to edit. Find the spreadsheet you want to look up on the list of your saved files, and open it.
3
Click an empty cell in the spreadsheet. You can use any empty cell to insert the round-up formula for your data.
4
Type =ROUNDUP(cell, decimals) into the empty cell. This formula allows you to pull numeric data from another cell, and round it up to any number of decimal places.
5
Replace cell in the formula with the cell you want to round up. Delete "cell" in the formula, and type the number of the cell you want to round up.
- For example, if you want to round up the data in cell A2, replace "cell" with "A2" in the formula.
6
Replace decimals with the number of decimal places you want. Delete "decimals" in the formula, and type the decimal places you want to round up.
- For example, if you want to round the data in cell A2 to two decimal places, your formula will look like =ROUNDUP(A2, 2).
7
Hit ↵ Enter or ⏎ Return on your keyboard. This will pull the numeric data from the specified cell, and round it up to the number of decimals in the formula.
- You will see your rounded up data in the formula cell here.