How to use formulas in Google Sheets

[tongfkymm44]

If you want to use formulas in Google Sheets, follow these steps:

Open the spreadsheet you want.
Click an empty cell.
Enter the equal sign first.
Enter the reference of the first cell involved in the formula.
Add the corresponding mathematical operator.
Enter the reference of the second cell.
You can add more operators and references if necessary. You will see the preliminary pastors in the us email database result above the cell, and pressing [Enter] will insert the final result of the calculation into the cell.
You can also use the formula bar to enter and adjust the formula in the selected cell. In both cases, the related cells will automatically appear highlighted in color.

Screenshot of a formula in the formula bar
You can enter the formula in the cell or in the formula bar.
Examples of formulas in Google Sheets
To demonstrate how formulas work in Google Sheets, here are some practical examples, using a table with sales data, product numbers, and the corresponding product price.

Addition and subtraction example
To add the values ​​in cells C4, C9, and C11, you must do the following:

Click any free cell to enter the sum result. In this example, cell C19 is used.
Enter the equal sign =, followed by C4, a plus sign +, C9, another plus sign +, and finally C11.
Press the [Enter] key to confirm and execute the addition.
Now you can see the result of the sum of the three values ​​in cell C19: 206.54 euros.

Screenshot of the sum formula in Google Sheets
Confirm the sum with [Enter] to obtain the result.
If you want to subtract values ​​from each other, the process is similar to that of addition: just swap the operator. This example shows the result of subtracting C4 from C10. Confirming with [Enter] will give you 67.49 euros.

Screenshot of the subtraction formula in Google Sheets
Subtraction works in a similar way to addition.
Multiplication example
The process is very similar to performing multiplications or divisions. In this example, the table has been expanded to include, in addition to the date of sale, the volume of units sold, the product number and the price. If you want to calculate the turnover of product 331-994 on January 4, 2024, follow these steps:

Click cell E11.
Enter an equal sign again =.
After the equal sign, enter the following formula: C11*D11.
Confirm with the [Enter] key.
The cell will show the result immediately: 875.00 euros.

Screenshot after a multiplication in Google Sheets
The result of the multiplication appears directly in the corresponding cell.
Integrating functions into Google Sheets formulas
Because functions offer much greater capabilities, it can be useful to integrate them into a formula. The following example uses the SUM function to calculate how many products with serial number 331-773 were sold in a given period. Follow these steps to integrate the function into your formula:

Click cell D17.
Enter the equal sign first =.
Enter the SUM function and then write an open parenthesis SUM (.
Enter cell references D2, D6, D10, D11and D14, and separate them with plus signs + .
Close the parenthesis.
Press the [Enter] key, you will get the result: 53.
Screenshot of a formula with an embedded function in Google Sheets
Features often give you even more options.
Show formulas after the fact
To display formulas used in Google Sheets instead of calculation results, follow these steps:

Click on the “View” tab in the top menu.
Place the cursor over the “Show” option, which has an icon with an eye.