Skip to content
LogoTechnipages
LogoTechnipages
  • Topics
        • Android
        • Browsers
        • Gaming
        • Hardware
        • Internet
        • iPhone
        • Linux
        • macOS
        • Office
        • Reviews
        • Software
        • Windows
        • Definitions
        • All Recent Posts
  • Product Reviews
  • About

Google Sheets: How to Round Numbers

Mel HawthorneMarch 12, 2020 Comments (0)
Google Sheets Header

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

Categories: Internet

Author Mel Hawthorne

You Might Also Like

  • How to Check if Your Passwords Have Been Leaked in a Data Breach

    Mel HawthorneInternet
  • Can Protonmail Be Traced?

    Mel HawthorneInternet
  • Amazon: How to Change Your Password

    Mel HawthorneInternet
  • How to Find Watched Videos on Facebook in 2023

    Susan SheffieldInternet

Leave a Reply

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

  • battery issues after windows 11 update

    Battery Issues After Windows 11 Update? Here’s the Fix

  • why is ram so expensive

    Why Is RAM Suddenly So Expensive?

  • how to fix error code 0x800f0922 windows 11

    How to Fix Error Code 0x800f0922 in Windows 11

  • service outage message on Xbox

    What to Do With a Service Outage Message on Xbox

  • signs your hdd is failing

    Signs That Your HDD Is Failing

profile pic

The Experts Behind Technipages

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.

Learn More

technipages logo white
linkedin icon

Technipages is part of Guiding Tech Media, a leading digital media publisher focused on helping people figure out technology. Learn more about our mission and team here.

© 2026 Guiding Tech Media All Rights Reserved

  • About Us
  • Contact
  • Terms of Use
  • Privacy Policy

© 2026 Guiding Tech Media All Rights Reserved

Information from your device can be used to personalize your ad experience.
Do not sell my personal information.

Last Updated on March 12, 2020 by Mitch Bartlett