• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Google Sheets: How to Round Numbers

Google Sheets: How to Round Numbers

By Mel Hawthorne Leave a Comment

Google Sheets offers most of if not all the options that Office Excel does – this includes functions like rounding numbers. If you’d like to round something in a Google sheet, here is how to do it.

You’ll need to use a formula – the Round formula, to be precise. Click into an empty cell and type =ROUND(number), then press enter. The number you entered will be rounded up or down to the last decimal place. For example, 9.52 will be rounded to 9.50.

Tip: Rounding in this way follows the normal rules – the numbers 0,1,2,3 and 4 will be rounded down, while 5,6,7,8 and 9 will be rounded up.

If you want to round your number to a specific number of decimals, you can do that too. It’s the same formula but in a slightly different format. Type =ROUND(number, decimals) and press enter.

An example round function.

An example would be =ROUND(9.1283912893, 2). In this case, the resulting number would be 9.13.

Tip: If you want to round your number up, ignoring the normal rules of rounding up for digits of 5 and above, and down for 4 and below, you need to use the =ROUNDUP(number, decimals) formula instead. =ROUNDUP(28.123, 2) will result in 28.13 (instead of 28.12 as it would be in ROUND). Similarly, the opposite would be =ROUNDDOWN(number, decimals). In this case, the number will always be rounded down, and =ROUNDDOWN(28.128, 2) becomes 28.12 (instead of 28.13 as it would be in ROUND).

You Might Also Like

  • How to Convert Google Sheets to PDF
    How to Convert Google Sheets to PDF
  • Google Sheets: How to Shade Every Other Row
    Google Sheets: How to Shade Every Other Row
  • Troubleshooting Google Sheets Goes Blank
    Troubleshooting Google Sheets Goes Blank
  • Google Sheets Won't Let Me Type - Fix Guide
    Google Sheets Won't Let Me Type - Fix Guide
  • Troubleshooting Google Sheets Not Printing
    Troubleshooting Google Sheets Not Printing
  • Troubleshooting Google Sheets Not Working
    Troubleshooting Google Sheets Not Working
  • How to Highlight Text in Google Sheets
    How to Highlight Text in Google Sheets
  • How to Spell Check in Google Sheets
    How to Spell Check in Google Sheets
  • How to Set Editing Permissions in Google Sheets
    How to Set Editing Permissions in Google Sheets

Filed Under: Internet Tagged With: Google Sheets

Reader Interactions

Did this help? Let us know!

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Windows 11: How to Fix Windows 11 Won’t Connect to a Network
  • What to Do When Firefox Won’t Load a Page
  • Chrome: How to Refresh Various Tabs Simultaneously
  • The Latest Foldable Phones – A Look At The Huawei Mate X2
  • Everything Announced at Google I/O 2022 That You Should Care About
  • How to Build the Best High-Spec PC for Your Budget
  • Google Shows Off Pixel 7 and Pixel Watch Ahead of Fall Launch
  • Windows 11: How to View Saved Passwords

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • Top 10 Google Chrome Alternatives to Surf Better

© Copyright 2022 Technipages · All Rights Reserved · Privacy