Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    3.  =8 / 5 (Dividing 8 by 5)
                     4.  =8 ^ 5 (Raising 8 to the power of 5)

                     The results will be 3, 40, 1.6 and 32768 respectively. Some formulas based on BEDMAS rule can be
                     entered as:
                     1.  =(8 + 5) – (2 + 3) ^ 2
                     2.  =(9/3) * (4 ^ 2) – 5

                                                                Tech Fact
                            Excel 2016 follows BEDMAS rule for doing mathematical calculations, where B stands
                             for Brackets, E for Exponentiation, D for Division, M for Multiplication, A for Addition
                                                           and S for Subtraction.

                     You can perform calculations using cell references in the following manner:

                     When you select a cell (like C1) in Google Sheets, you can see the formula you typed in the Formula
                     bar at the top of the screen. This is where the formula appears, and you can edit it directly if
                     needed.

                     A formula in Google Sheets is made up of three main elements:
                     1.  References: These are the cells or ranges of cells you want to use in your calculation. For
                         example, A1 or B2:B5

                     2.  Operators: These are symbols like +, -, *, /, ^, %, and others that define what kind of calculation
                         you want to do.
                     3.  Constants: These are fixed numbers or text values that do not change, like 5 or "Hello".
                     These features are present in Google Sheets, and you can use them to create your own formulas

                     for calculations.

                            ORDER OF OPERATION

                     When you perform calculations using a formula in Google Sheets, the program follows certain
                     rules to decide the order in which calculations are done:
                         Parentheses: Google Sheets will calculate anything inside parentheses first. So, if you have a

                         formula like (5 + 5), Google Sheets will calculate the sum before doing anything else.
                         Multiplication  and  Division: Google  Sheets  calculates  multiplication  and division  before
                         addition and subtraction.
                         Left to Right: If there are multiple operators with the same level of precedence (like addition
                         and subtraction), Google Sheets will calculate them from left to right.

                                                                                Formulas and Functions in Google Sheets  81

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