What are logical operators in Excel?
Logical operators are also known as comparison operators because their primary purpose is to compare two values.
These operators always only consider the value. And that’s regardless of how it is derived – even if it’s from a formula.
Also, a logical operator never returns numerical values in the result, only TRUE and FALSE. The value of TRUE and FALSE is 1 and 0, respectively – which are binary digits.
The comparison operators can also handle any Boolean expression. Hence, they are called Boolean operators.
In Excel, there are six Boolean operators you can use. These are:
- Less than
- Less than or equal to
- Greater than
- Greater than or equal to
- Equal to
- Not Equal to
Let’s study all these operators in depth below 🚀