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.