Page 23 - Trackpad_V1_Book 6_Flipbook
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   Relational Operators (=, <, >, <=, >=, <>)





                          WAYS TO ENTER A FORMULA IN EXCEL 2010

                 We can enter a formula in two ways:

                 ENTER A FORMULA DIRECTLY INTO THE CELL

                 Enter a formula in the cell after typing an equal sign. Now, press Enter key to see the result of the
                 formula in the cell.






















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