How to Divide on Google Sheets on PC or Mac

This wikiHow teaches you how to use a formula in Google Sheets to do division calculations from raw numeric data, using a desktop internet browser.

Steps

  1. Image titled Divide on Google Sheets on PC or Mac Step 1
    1
    Open Google Sheets in your internet browser. Type sheets.google.com into the address bar, and hit ↵ Enter or ⏎ Return on your keyboard.
  2. Image titled Divide on Google Sheets on PC or Mac Step 2
    2
    Click a spreadsheet file. Find the file you want to edit on the list of your saved spreadsheets, and open it.
    Advertisement
  3. Image titled Divide on Google Sheets on PC or Mac Step 3
    3
    Click an empty cell. Find an empty cell to use for your numerator value, and click it.
  4. Image titled Divide on Google Sheets on PC or Mac Step 4
    4
    Enter your numerator value into the empty cell. The numerator is the number at the top of a fraction.
    • You don't have to enter an integer for your numerator or denominator. Feel free to use decimal values here.
  5. Image titled Divide on Google Sheets on PC or Mac Step 5
    5
    Click another empty cell. Find an empty cell for your denominator value, and click it.
  6. Image titled Divide on Google Sheets on PC or Mac Step 6
    6
    Enter your denominator value into the cell. The denominator is the number at the bottom of a fraction.
    • You will divide your numerator by your denominator.
  7. Image titled Divide on Google Sheets on PC or Mac Step 7
    7
    Click another empty cell for your division formula. Find an empty cell for your formula anywhere on the spreadsheet, and click it.
  8. Image titled Divide on Google Sheets on PC or Mac Step 8
    8
    Enter =num/den into the empty formula cell. This is the simple division formula, which will make an exact calculation for you.
    • In the division formula, num represents your numerator, and den represents the denominator.
  9. Image titled Divide on Google Sheets on PC or Mac Step 9
    9
    Replace num and den with their corresponding cell numbers. Find the exact column letter and row number for your numerator and denominator cells, and insert the cell numbers into the raw formula.
    • For example, if your numerator value is in cell A1, and your denominator is in cell A2, your formula should look like =A1/A2.
  10. Image titled Divide on Google Sheets on PC or Mac Step 10
    10
    Hit ↵ Enter or ⏎ Return on your keyboard. This will make the calculation, and show the results in the formula cell.
    Advertisement

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Write a Review on Google
How to
Write a Review on Google
Search by Image on Google
How to
Search by Image on Google
Buy a Google Play Gift Card Online on Android
How to
Buy a Google Play Gift Card Online on Android
Access Google Assistant
How to
Access Google Assistant
Restore Google Authenticator
How to
Restore Google Authenticator
Make a Google Account Without Gmail
How to
Make a Google Account Without Gmail
Get a Google Voice Phone Number
How to
Get a Google Voice Phone Number
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
How to
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Create a Google Profile
How to
Create a Google Profile
Use Google Translate
How to
Use Google Translate
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Advertisement

About This Article

wikiHow Staff
Co-authored by:
wikiHow Staff
wikiHow Staff Writer
This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards. This article has been viewed 7,628 times.
How helpful is this?
Co-authors: 1
Updated: May 17, 2018
Views: 7,628
Categories: Google Applications | Spreadsheets
Article SummaryX

1. Open Google Sheets in a browser.
2. Click a spreadsheet.
3. Enter your numerator into an empty a cell.
4. Enter your denominator into another cell.
5. Type =num/den into another empty cell.
6. Replace num and den with their cell numbers.
7. Hit ↵ Enter or ⏎ Return on your keyboard.

Did this summary help you?
Advertisement