Placeholder Image

Subtitles section Play video

  • You can use basic formulas in Google Sheets.

  • To create a formula,

  • select the cell where you want to see your answer.

  • At the top of your screen,

  • click on the white bar next to the "fx" sign.

  • This is where the formulas are stored for each cell.

  • You'll be able to write formulas here

  • as well as edit them.

  • Let's use a formula to add up how much stock we have.

  • First, double-click where you want the total,

  • and then type the equation in the "fx" bar.

  • Always start a formula with an equals sign

  • followed by the formula instruction.

  • Type "="

  • followed by "SUM" in capital letters

  • followed by "("

  • followed by the range.

  • Our range is from D5 to D13,

  • as these are the numbers we want to total.

  • So we'll type "D5:D13"

  • followed by a closed bracket sign

  • to complete the equation.

  • Press enter.

  • If the formula has been entered correctly,

  • the total will immediately be shown in the cell.

  • If you've made a mistake,

  • perhaps you've misspelled something,

  • an error symbol will appear, like this.

  • Then you should go back to your "fx" bar,

  • and you can edit it until it's correct.

  • You can learn how to create other formulas

  • by learning the Google Sheets language.

You can use basic formulas in Google Sheets.

Subtitles and vocabulary

Click the word to look it up Click the word to find further inforamtion about it