Page 84 - 2619_PlusGPT V2.1_C-7

For example, the formula = 10 + 10 * 2 in Google Sheets gives a result of 30 because it multiplies 10
by 2 first and then adds 10. But if you use parentheses like this: = (10 + 10) * 2, Google Sheets will
calculate the expression inside the parentheses first (20), and then multiply by 2, giving a result
of 40.

If you're ever unsure about the order in which calculations are done, you can use parentheses to
be clear, even if they aren’t strictly necessary. Parentheses can also make your formulas easier
to understand.

DIFFERENT WAYS TO ENTER FORMULAS

In Google Sheets, there are mainly two ways to enter a formula in a worksheet:
1. Typing the formula directly in the cell: In this method, you type the formula directly into the

cell after typing an equal sign (=). For example, if you want to add two numbers, you can type
=5+5 in a cell. Once you press the Enter key, Google Sheets will calculate the result and display
it in the same cell.

Formula in cell

Output
2. Typing the formula in the Formula bar: In Google Sheets, you can also enter a formula using

the Formula bar. First, select the cell where you want the result to appear, then go to the
Formula bar at the top of the cells and type your formula after the equal sign (=). Once you've
entered the formula, press the Enter key, and the result will appear in the selected cell.

Formula in Formula bar

82 Premium Edition-VII