Comparing Values With Operators
Use greater-than, less-than, and equals to build logical tests.
What Is a Comparison Operator?
An IF test is only as smart as the question you ask. Comparison operators are the symbols that let you ask those questions.
They compare two values and hand back a simple answer: TRUE or FALSE. That answer is exactly what IF needs to choose an outcome.
The Six Operators
There are six comparison operators you will use constantly:
=equal to>greater than<less than>=greater than or equal to<=less than or equal to<>not equal to
Each one produces TRUE or FALSE when placed between two values.
All lessons in this course
- How the IF Function Thinks
- Comparing Values With Operators
- Returning Text or Numbers From IF
- Common IF Mistakes to Avoid