Logical Operators

Excel is not only a great way to store and organize data and powerful calculation tool, it can also evaluate logical arguments such as greater than, less than, not equal to, equal to, etc. When you enter a logical expression in a formula, Excel will evaluate the equation and will result in either TRUE or FALSE. In math these operations are referred to as inequalities. Learning how to use these logical operations in Excel is important because many of the Excel formulas utilize logical arguments. See the table below for a list of the logical operators available in Excel and examples of formulas containing them.

Excel_Logical_Operators

How to read the inequality equations:

How to read Excel Logical or inequality formulas

*Notice how, in the example formulas above, the formulas all begin with the equals sign ( = ). The equals sign tells Excel that you want to perform a calculation or enter a formula—if you do not use the equals sign in a formula, Excel will interpret the data inputted into the cell as text. Additionally, in Excel, the numbers in the sample formulas above can be replaced with cell references (i.e., A2 or B5, etc.) or other formulas that result in a value.

 

Leave a Reply