Quick, clean, and to the point

Logical operators

Logical operators in Excel formulas

Excel's 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:

Operator Meaning Example
= Equal to =A1=10
<> Not equal to =A1<>10
> Greater than =A1>100
< Less than =A1<100
>= Greater than or equal to =A1>=75
<= Less than or equal to =A1<0

Note: all Excel formulas must begin with an equal sign (=). This is a syntax requirement, not a logical comparison.

Math operators are listed here. See this list of formulas for many examples of logical operators in formulas. Note that a text value is greater than any number in Excel.