Google Sheets

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

Rather than typing cell addresses, you can point and click on the cells you wish to include in your formula.

1. Select the cell that will display the calculated value (E18, for example).
   
   Selecting cell E18
2. Type the equals sign (=).
3. Click on the cell you wish to reference first in the formula (for example, E16). The address of the cell appears in the formula.
   
   Clicking cell E16
4. Type the operator you wish to use in the formula. For example, type the multiplication sign (*).
5. Click on the cell you wish to reference second in the formula (for example, E17). The address of the cell appears in the formula.
   
   Clicking cell E17
6. Press the Enter key on your keyboard. The formula will be calculated, and the value will appear in the cell.
   
   The calculated value in E18