In this article, we will learn about operators and how to use them in formulas in excel.
For instance, we have a list of values and we need to perform a criteria on the list using the operator in formulas. For this, we will be learning about different types of operators. We will be using different function operations depending on the ease of the formula.
The following operators will be useful in excel. Let's study about them first. There are two types of operators.
These operators are used with or without a formula to compare the value of same data type like text matching text or number matching number. Most operators are used with absolute or relative cell references.
Logical operators
The above mentioned operators are quite well known and widely used. See the below snapshot for the usage of the logical operators operators
See the table below for more understanding.
Operator | value | Formula | Operation (Result) |
= | 10 | = B2 = 10 | TRUE |
<> | 20 | = B3 <> 20 | FALSE |
< | 30 | = B4 < 50 | TRUE |
<= | 20 | = B5 <= 15 | FALSE |
> | 10 | = B6 > 9 | TRUE |
>= | 0 | = B7 >= 0 | TRUE |
Notes:
Mathematical operators
The above mentioned operators are quite well known and widely used. See the below snapshot for the usage of the logical operators.
See the below table.
Operator | Formula | Result |
+ | = E2 + E3 | 30 |
- | = E4 - E3 | 10 |
* | = E6 * E7 | 0 |
/ | = E5 / E6 | 2 |
^ | = E4 ^ 2 | 900 |
() | = ( E3 + E5 ) / 2 | 20 |
& | = "B" & E6 | B10 |
: | = MAX ( E2:E7 ) |
Wait!!!. What if there is more than 1 operator in a formula? What operation would excel be performing first? That's cool. For this, Excel already has predefined order of operations. Take a look at the order list below.
Hope you understood how to use Mathematical and Logical operations in Excel. Explore more articles on Excel operators in formulas here. Please feel free to state your query or feedback for the above article. We will assist you.
Related Articles
Vlookup Top 5 Values with Duplicate Values Using INDEX-MATCH in Excel
VLOOKUP with Dynamic Col Index
Partial match with VLOOKUP function
Popular Articles
Convert Inches To Feet and Inches in Excel 2016
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.