Excel logical operators are used in formulas to perform comparisons, and to build formula criteria. Logical operators can be used in formulas on their own, or combined with each other and/or other functions. The table below lists the logical operators available in Excel:
Excel Logical Operators
| Logical Operator | Meaning |
|---|---|
| = | Equal to |
| <> | Not Equal to |
| > | Greater Than |
| < | Less Than |
| >= | Greater Than or Equal to |
| <= | Less Than or Equal to |