scorecard
  1. Home
  2. tech
  3. how-to
  4. How to create Google Sheets formulas to help you make calculations on a spreadsheet

How to create Google Sheets formulas to help you make calculations on a spreadsheet

Dave Johnson   

How to create Google Sheets formulas to help you make calculations on a spreadsheet
  • To add a formula in Google Sheets, click the cell where you want the answer, then choose one of the hundreds of functions.
  • To start a formula in a web browser, you need to enter an equals sign.
  • You don't need the equals sign in the mobile app unless you're entering a function manually.

While almost anyone can perform rudimentary calculations in Google Sheets without resorting to formulas, if you want to do more than simple arithmetic, it's incredibly useful to be able to create formulas in Google Sheets. There are hundreds of potential formulas you can work with, making Google Sheets a powerful tool.

Simply put, a formula performs some sort of calculation on the contents of one or more cells. When properly formatted, a formula always begins with an equals sign, is followed by a function (which tells the formula what to do), and you typically need to specify one or more cells for the function to act on within a set of parentheses.

How to create Google Sheets formulas on a computer

1. Open Google Sheets in a web browser and click the cell in which you want the formula's answer to appear.

2. Find the Formula Bar above the spreadsheet. It's a blank field to the right of the Fx symbol. Click in the field and type the equals symbol "=".

3. Type the function you want to add to the formula. For example, if you want to sum up a column of numbers, type "SUM" and click SUM when you see it appear in the list of functions.

4. Google Sheets automatically adds an open parenthesis.

5. Enter the range of cells you want to sum. You can type the range, such as A1:A9, or you can click and drag the mouse from the first cell in the range to the last.

6. Type the closing parenthesis and press Enter.

If you don't know the exact function you need, you can browse the list of functions. Click in the Formula Bar and choose Insert, then Function. Find the function you want from the menu and click it.

Quick tip: It isn't always obvious what a function needs or how to format it. To see detailed help about all functions, click Help in the menu bar and then Function Help.

How to create Google Sheets formulas on a mobile device

1. Start the Google Sheets app on your Android or iOS device and tap the cell in which you want the formula's answer to appear.

2. On an Android phone, tap the fx symbol below the spreadsheet. On iOS, tap the Pencil icon at the bottom right, then tap the fx symbol.

3. In the list of functions, tap browse the categories. Tap the category you need followed by the function you want to insert in your formula.

4. Google Sheets guides you through creating the formula with formatting hints. Choose the cell or range of cells you need to properly complete the formula. To make a range of cells, tap the first cell in the range and then tap the last cell in the range.

5. Tap the checkmark to the right of the Function Bar.

Quick tip: You can enter cells in your formulas by typing the names of the cells, such as A1 or N17.

READ MORE ARTICLES ON



Popular Right Now



Advertisement