views

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.
Comments
0 comment