Creating Simple Formulas

In Google Sheets simple formulas can help you calculate important data. Learn how to create simple formulas in Google Sheets.

To create a formula using the point-and-click method:

Rather than type cell addresses, you can point and click the cells you want to include in your formula.

  1. Select the cell that will display the calculated value.Selecting the cell
  2. Type the equals sign (=).
  3. Click the cell you want to reference first in the formula. The address of the cell appears in the formula.
    Entering the first cell reference
  4. Type the operator you want to use in the formula. For example, type the multiplication sign (*).

  5. Click the cell you want to reference second in the formula. The address of the cell appears in the formula.Completing the cell reference

  6. Press the Enter key on your keyboard. The formula will be calculated, and the value will appear in the cell.

    The calculated value