Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
- Power Bi (35+)
Logical operators are also known as the comparison operators in excel and they are used to compare two or more values, the return output given by these operators are either true or false, we get true value when the conditions match the criteria and false as a result when the conditions do not match the criteria.
List of Logical Excel Operators
Logical Excel Operator symbols are used to compare two or more values in Excel. When you compare one value against the other we get the result in Boolean type. Boolean values are TRUE or FALSE.
Below are the most commonly used logical operators in excel –
|Sr No.||Logical Operator Excel Symbol||Operator Name||Description|
|1||=||Equal to||Compares One Value to Other Value|
|2||>||Greater Than||Tests whether the value is greater than a certain value or not|
|3||<||Less Than||Tests whether the value is less than a certain value or not|
|4||>=||Greater Than or Equal To||Tests whether the value is greater than or equal to a certain value or not|
|5||<=||Less Than or Equal To||Tests whether the value is less than or equal to a certain value or not|
|6||<>||Not Equal To||Tests whether a particular value is not equal to a certain value or not|
Now we will look at each one them in detail.
#1 – Equal Sign (=) to Compare Two Values
We can use the equal sign (=) to compare one cell value against the other cell value. We can compare all types of values using an equal sign. Assume we have below values from cell A1 to B5.
Now I want to test whether the value in cell A1 is equal to cell B1 value.
Step 1: In order to select the value of A1 to B1 let us open the formula with an equal sign.
Step 2: Select cell A1 now.
Step 3: Now type the one more excel logical operator symbol equal sign (=).
Step 4: Now select the second cell we are comparing i.e. B2 cell.
Step 5: Ok we are done. Let hit enter key to close the formula. Copy and paste to other cells.
So we got TRUE as the result if the cell 1 value is equal to cell 2 or else we got FALSE as the result.
#2 – Greater Than (>) Sign to Compare Numerical Values
Unlike equal sign (=) greater than sign (>) can only test numerical values, not text values. For example, if your values in cell A1 to A5 and you want to test whether these values are greater than (>) the value of 40 or not.
Step 1: Open the formula in B2 cell and select the cell A2 as the cell reference.
Step 2: Since we are testing the value is greater than mention > symbol and apply the condition as 40.
Step 3: Close the formula and apply to remaining cells.
Only one value is >40 i.e. cell A3 value.
In the cell A6 value is 40, since we have applied the excel logical operator > as the criteria formula returned the result is FALSE. We will see how to solve this issue in the next example.
#3 – Greater Than or Equal To (>=) Sign to Compare Numerical Values
In the previous example, we have seen the formula returned TRUE value only to those values which are greater than the criteria value. But if the criteria value is also to be included in the formula then we need to use the >= symbol.
Previous formula excluded the value of 40 but this formula included.
#4 – Less than Sign (<) to Compare Numerical Values
Like how greater than tests the numerical values, similarly less than also tests the numbers. I have applied the formula as <40.
It works completely opposite to the greater than criteria. It has returned TRUE to all those values which are less than the value of 40.
#5 – Less Than or Equal To Sign (<=) to Compare Numerical Values
Like how >= sign included the criteria value also in the formula similarly, <= also performs the same way.
This formula included the criteria value in the formula, so the value of 40 is returned as TRUE.
#6 – Not Equal Sign (<>) to Compare Numerical Values
Combination of greater than (>) and less than (<) signs make the operator sign not equal to <>. This works completely the opposite to equal sign. The equal sign (=) tests whether the one value is equal to other value and returns TRUE, whereas not equal to sign <> returns TRUE if the one value is not equal to another value and returns FALSE if the one value is equal to another one.
As I told A3 & B3 cell values are same but formula returned FALSE which is completely different than the EQUAL sign logical operator in excel.
Logical Operator in Excel with Formulas
We can also use logical operator symbols in other excel formulas. IF Excel function is one of the often used formulae with logical operators in excel.
#1 – IF with Equal Sign
If the function tests the condition is equal to a certain value or not. If the value is equal then we can have own value. Below is a simple example of that.
The formula returns Same if the cell A2 value is equal to B2 value, if not it will return Different.
#2 – IF with Greater Than Sign
We can test certain numerical values and arrive results if the condition is TRUE and return a different result if the condition is FALSE.
#3 – IF with Less Than Sign
Below formula will show the logic of applying if with less than the excel logical operators.
Things to Remember About Logical Operators in Excel
- Excel logical operator symbols return only TRUE or FALSE as the result.
- Combination of > & < symbols make not equal sing <>.
- >= & <= sign includes the criteria also in the formula.
This has been a guide to Logical Operators in Excel. Here we discuss the top 6 types of MS Excel Logical Operators along with practical examples and downloadable excel template. You may learn more about excel from the following articles –