Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 84 - 2619_PlusGPT V2.1_C-7
P. 84

    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

| 79 80 81 82 83 84 85 86 87 88 89 |