Logical Operators in Excel:
Equal to, Not equal to, Greater than, Less than (+much more)
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Most of the operators you use in Excel are probably mathematical, like +, -, *, and /.
But there’s another set of useful operators: the logical operators.
Statements like “greater than,” “less than or equal to,” and “not equal to” can be very useful when you’re analyzing data.
These comparison operators return a TRUE or FALSE value that can be used with logical functions to give you even more options.
Let’s take a look at each one of these operators, and then see how you can use them with the IF function.
*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.