Using 'Equal to' logical operator in Excel But in fact, each logical operator has its own specificities and knowing them can help you harness the real power of Excel formulas. It may seem that the above table covers it all and there's nothing more to talk about. The screenshot below demonstrates the results returned by Equal to, Not equal to, Greater than and Less than logical operators: The formula returns TRUE if a value in cell A1 is less than or equal to the values in cell B1 FALSE otherwise. The formula returns TRUE if a value in cell A1 is greater than or equal to the values in cell B1 FALSE otherwise. The formula returns TRUE if a value in cell A1 is greater than a value in cell B1 otherwise it returns FALSE. The formula returns TRUE if a value in cell A1 is not equal to the value in cell B1 FALSE otherwise. The formula returns TRUE if a value in cell A1 is equal to the values in cell B1 FALSE otherwise.

The following table explains what each of them does and illustrates the theory with formula examples. Six logical operators are available in Excel. Logical operators are sometimes called Boolean operators because the result of the comparison in any given case can only be either TRUE or FALSE. Common uses of logical operators in ExcelДЄ logical operator is used in Excel to compare two values.

Greater than / less than / greater than or equal to / less than or equal to.This tutorial aims to help you understand the insight of Excel logical operators and write the most efficient formulas for your data analysis. For this, Microsoft Excel provides six logical operators, which are also called comparison operators. Many tasks you perform in Excel involve comparing data in different cells.

Symbols greater than less than equal to