Skip to main content

Introduction

Learn How To Round A Number Up Or Down Using Google Sheets.

  1. Typing "google.com" in the address bar to go to the google website
    • Typing "google.com" in the address bar to go to the google website

  2. Click on the "Sign In" button to sign in your google account
    • Click on the "Sign In" button to sign in your google account

  3. Type your email address into this box
    • Type your email address into this box

    • Click on the blue "Next" button

  4. Type your password into this box
    • Type your password into this box

    • Click on the blue "Sign In" button

  5. Click this button to open a menu of options
    • Click this button to open a menu of options

    • Click on the "Sheet" button

  6. Click + button to create new spreadsheet
    • Click + button to create new spreadsheet

  7. Type in a cell "=ROUND(Value, [places])".
    • Type in a cell "=ROUND(Value, [places])".

    • Summary Rounds a number to a certain number of decimal places according to standard rules. value The value to round to places number of places. places - [optional] The number of decimal places to which to round.

  8. Here is the rounded number
    • Here is the rounded number

    • Here is the formula =ROUND( Value, [places]) with numbers substituted in (=ROUND(99.44444, 2))

  9. Here is the rounded number
    • Here is the rounded number

    • Here is the formula =ROUNDUP( Value, [places]) with numbers substituted in (=ROUNDUP(99.44444, 1))

  10. Here is the number that needs to be rounded
    • Here is the number that needs to be rounded

    • Here is the formula =ROUNDDOWN( Value, [places]) with numbers substituted in (=ROUNDDOWN(99.44444, 1))

Finish Line

One other person completed this guide.

Aaron

Member since: 06/08/2015

1 Reputation

42 Guides authored

0 Comments

Add Comment

View Statistics:

Past 24 Hours: 0

Past 7 Days: 0

Past 30 Days: 0

All Time: 39