How to Round Up on Google Sheets on PC or Mac
How to Round Up on Google Sheets on PC or Mac
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

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.

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.

Click an empty cell in the spreadsheet. You can use any empty cell to insert the round-up formula for your data.

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.

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.

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).

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.

What's your reaction?

Comments

https://shivann.com/assets/images/user-avatar-s.jpg

0 comment

Write the first comment for this!