Exceljet

Quick, clean, and to the point

Logical operators

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.

See this list of formulas for many examples of logical operators in formulas.