Page 11 - 2403_Trackpad_V5.1_C6_Fb
P. 11

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 colon(:) (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 in Excel 2021  9
   6   7   8   9   10   11   12   13   14   15   16