Comparison operators compare two values. You can compare any type of data, including numbers, dates, and character strings.
The comparison result can either be:
•TRUE: The expression is true.
•FALSE: The expression is false.
Comparison operator |
Meaning |
Example |
|---|---|---|
= |
Equal to |
=6=6 |
> |
Greater than |
=9>17 |
< |
Less than |
=A2<C3 |
>= |
Greater than or equal to |
=0>=6 |
<= |
Less than or equal to |
=P12<=7 |
<> |
Not equal to |
=3<>4 |