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.

點擊 "fx "標誌旁邊的白色條。

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.

然後在 "fx "欄中輸入公式。

Always start a formula with an equals sign

始終以等號開始一個公式

followed by the formula instruction.

後面是公式指令。

Type "="

輸入"="

followed by "SUM" in capital letters

後面的大寫字母 "SUM"。

followed by "("

後面是"("

followed by the range.

其次是範圍。

Our range is from D5 to D13,

我們的範圍是從D5到D13。

as these are the numbers we want to total.

因為這些都是我們要總計的數字。

So we'll type "D5:D13"

所以我們就打 "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,

那麼你應該回到你的 "fx "吧。

and you can edit it until it's correct.

你可以編輯它，直到它的正確性。

You can learn how to create other formulas

你可以學習如何創建其他公式。

by learning the Google Sheets language.

通過學習Google Sheets語言。