Sheets will do all our calculations for us if we tell it what we want. Better yet, we can give it a single formula and have it apply it to multiple rows.

To enter a formula, cells need to be referenced. This can be done by directly clicking on them or by typing a reference.

To reference this | Type this | Example |
---|---|---|

A cell on the same sheet | the column letter followed by the row number | B5 |

A cell on a different sheet | the sheet name in single quotes, followed by an exclamation mark, the column letter, and the row number | 'Tax Rates'!B5 |

A range of cells | the reference of the first cell, followed by a colon and the reference of the last cell | B5:E9 |

To enter a formula, type "=" followed by the expression.

Formulas can be repeated without retyping. Sheets can automatically change the cell references in the formula to adjust for the new location.

To repeat a formula | Do this | Example |
---|---|---|

With automatic adjustment | Click on the cell with the formula already typed, and drag the box in the lower right corner. | =G4*H4 in cell I4 will change to =G5*H5 when dragged down to row 5. |

Without automatic adjustment | Add a "$" in front of each letter or number you don't want to change, and then do as above. | =G$4*H$4 in cell I4 will stay =G$4*H$4 when dragged. |

- Type =G4*H4 in cell I4 to calculate the total price of the first item.
- Repeat this formula all the way down the spreadsheet.

➜ Try it