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.|