Page 23 - Trackpad_V5_Book 6
P. 23

COMPARISON OPERATORS

            These operators are used to compare two values with the given set of operators. When two values
            are compared by using these operators, the result is either True or False. Some comparison
            operators are = (equal to), > (greater than), < (less than), >= (greater than equal to), <= (less than
            equal to) and <> (not equal to).

            REFERENCE OPERATORS
            These operators are used to combine a range of cells for calculations. Some reference operators are :
            (range operator), comma(,) (union operator), space (intersection operator). Range operator produces
            one reference to all the cells between two references. Union operator combines multiple references
            into one reference. Intersection operator produces a reference to cells common to the two references.



                     OPERATORS PRECEDENCE

            In  a numeric  formula, the  results  of the  formula are calculated  based  on the  given order of
            precedence:


              1   Colon (:), single space, comma (,)            2  Percentage (%)



              3   Exponent (^)                                  4  Multiplication (*) and Division (/)


              5   Addition (+) and Subtraction (-)              6   Comparison Operators (=, <, >, <=, >=, <>)





                     WAYS TO ENTER A FORMULA IN EXCEL 2021

            We can enter a formula in two ways:


            ENTER A FORMULA DIRECTLY INTO THE CELL
            Enter a formula into the cell after typing an equals sign. Now, press the Enter key to see the result
            of the formula in the cell.















            ENTER FORMULA IN THE FORMULA BAR

            Select the cell and enter the formula in the Formula bar after typing an equal to sign. Now press
            the Enter key to see the result.




                                                                            Formulas and Functions in Excel 2021  21
   18   19   20   21   22   23   24   25   26   27   28