Page 273 - Trackpad IT-402_Class-IX
P. 273

Order of precedence             Operator
                                                  1                          ()

                                                  2                          ^
                                                  3                         / *
                                                  4                          +

            In the above order of precedence, / and * are in the same order. Similarly, + and - are in the same order. In an expression,
            if the operators of the same order are present, then the order of evaluation of the expression will be from left to right.

            Let's see some examples given below:
                                 Formula                   Evaluation                   Result

                                                         =5–4/2
                        =2+3-4/2                                                          3
                                                         =5–2
                                                         =10+2*16/2
                        =10+2*4^2/2                      =10+32/2                         26
                                                         =10+16
                                                         =36–4/4
                        =6*6-(1+3)/2^2                                                    35
                                                         =36–1
                                                         =3+5*16
                        =3+5*4^2                                                          83
                                                         =3+80
                                                         =2+2-3^2+10
                        =10/5+2-(1+2)^2+10               =4–9+10                          5
                                                         =–5+10




                                    Find the answers for the given expressions:
                     uiz Bee        a.  =5+6^2*4-3

                                    b. =(2+3–1)*6+2-12/6
                                    c.  =64/6+2*4-1
                                    d. =7+2–1*1/1^2




            Using Cell Address in Formula
            Instead of giving direct values in a formula, we can also give addresses of the cells containing values. For example to
            get the sum of the values in the cells A1 and A2, the formula =A1+A2 will be used in the cell A3.




















                                                                                          Electronic Spreadsheet  273
   268   269   270   271   272   273   274   275   276   277   278