ADVERTISEMENT
How to use Logical Or comparison operators In Excel | Understand Operators
Note: If video does not play,
just refresh page and then Play video or Just Click on this text.
Comparison operators
You can compare two values with the following operators. When two values are compared by using these operators, the result is a logical value—either TRUE or FALSE.
Comparison operator | Meaning | Example |
|---|---|---|
= (equal sign) | Equal to | =A1=B1 |
> (greater than sign) | Greater than | =A1>B1 |
Less than | =A1 | |
>= (greater than or equal to sign) | Greater than or equal to | =A1>=B1 |
Less than or equal to | =A1 | |
(not equal to sign) | Not equal to | =A1B1 |