- 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.
- Visit Insider’s Tech Reference library for more stories.
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 “=”.
Start every formula with an equals sign.
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.
A formula is typically composed of a function that works on a range of cells, contained in parenthesis.
If you don’t know the exact function …….