Page 23 - TP_Pro_V5.1_Class6
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 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 and Functions in Excel 2021 21

