This wikiHow teaches you how to use Google Sheets to round up a number to the nearest whole number. This can be done involves using Sheets’ fx function for rounding up numbers.
Steps
-
Open Google Sheets. It’s the green icon with a set of six white rectangles stacked on top of each other.
- You may need to tap the “Apps” icon or swipe up from the bottom of the home screen to search through your full list of apps.
-
Open a Sheets file. You can either open an existing file from your Google docs or create a new file by tapping the red + at the bottom right-hand side of the screen.Advertisement
-
Tap on the cell you want to use to round a number up.
-
Tap fx . This is found to the left of the text box that will allow you to enter numbers.
-
Tap Math .
- You may need to scroll down to see this option.
-
Scroll down and tap ROUNDUP .
-
Tap in between the () brackets in the text field.
-
Type the number you want to round up. When you tap away from this cell, it will automatically round your number up to the nearest whole number.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Thanks to all authors for creating a page that has been read 287 times.
Advertisement
