Google Spreadsheet Formula Tutorial: Step 3 of 3
Following the equal sign, we add in the cell references of the cells containing our data.
By using the cell references of our data in the formula, the formula will automatically update the answer if the data in cells A1, A2, or A3 changes.
The best way of adding cell references is by using the Google Spreadsheets feature called pointing.
Pointing allows you to click with your mouse on the cell containing your data to add its cell reference to the formula.
After the equal sign added in step 2
- Click on cell A1 with the mouse pointer to enter the cell reference into the formula.
- Type a plus ( + ) sign.
- Click on cell A2 with the mouse pointer to enter the cell reference into the formula.
- Type a minus ( - ) sign.
- Click on cell A3 with the mouse pointer to enter the cell reference into the formula.
- Press the ENTER key on the keyboard.
- The answer 1 should appear in cell A4.
- Click on cell A4. The complete formula = A1 + A2 - A3 is shown in the formula bar above the worksheet.
