Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 38 - CodePilot V5.0 C7
P. 38

    Logical operators: Logical operators are used to test and evaluate the conditions. Logical
                             OPERATORS
                                                                                                                                                    operators are:

                      Operators are symbols used in formulas to perform specific mathematical or logical operations.
                      Let’s learn about the different types of operators.
                          Arithmetic operators: These operators are used to perform the basic mathematical operations.

                         Arithmetic operators are:

                                                                                                                                                       ORDER OF OPERATIONS

                                                                                                                                                Order of Operations refers to the rules that determine the sequence in which calculations are

                                                                                                                                                performed in a formula. The standard order of operations in Excel is as follows:
                                                                                                                                                     Parentheses (): Operations inside parentheses are done first.
                          Comparison operators: These operators are used to compare two values and return either
                         TRUE or FALSE. Comparison operators are:                                                                                    Exponentiation ^: Exponents are calculated next.

                                                                                                                                                     Multiplication * and Division /: These are performed from left to right.
                                                                                                                                                     Addition + and Subtraction - : These are done last, also from left to right.

                                                                                                                                                This rule is often remembered using the acronym PEMDAS (Parentheses, Exponents, Multiplication
                                                                                                                                                and Division, Addition and Subtraction).

                                                                                                                                                Let’s calculate the result of the formula: =7 + 3 * 3 ^ 2, using the order of operations.
                                                                                                                                                 Step  1     Excel first calculates the exponent 3 ^ 2 = 9.

                                                                                                                                                 Step  2     Next, it performs the multiplication 3 * 9 = 27.

                                                                                                                                                 Step  3     Finally, it adds 7, 7 + 27 = 34.
                                                                                                                                                Result: 34

                          Text Concatenation operator: This operator is used to join or combine text from different                                    CELL REFERENCING IN FORMULAS AND ITS TYPES
                         cells. The text concatenation operator is:
                                                                                                                                                Cell referencing means using the address of a cell in a formula to get its value. This makes your
                                                                                                                                                formulas smart—if the value in the referenced cell changes, the formula will update automatically.
                                                                                                                                                There are three main types of cell references in Excel.

                                                                                                                                                RELATIVE CELL REFERENCE

                                                                                                                                                This is the most basic type of reference. When you copy or move a formula, the reference will
                                                                                                                                                change relative to its position.

                       36
                            CodePilot (V5.0)-VII

| 33 34 35 36 37 38 39 40 41 42 43 |