Learn how to test whether specific criteria in your spreadsheet are true or false.
Returns "True" if the statement is true, or "False" if the statement is false
= (Reference1 operator Reference2)
Logical functions use the comparison operators listed below:
|
Operator |
Meaning (Example) |
|
"=" (equal to) |
Equal to (A1=B1) |
|
> (greater than) |
Greater than (A1>B1) |
|
< (less than) |
Less than (A1<B1) |
|
>= (greater than or equal to) |
Greater than or equal to (A1>=B1) |
|
<= (less than or equal to) |
Less than or equal to (A1<=B1) |
|
<> (not equal to) |
Not equal to (A1<>B1) |
Continue Learning Excel
Practice spreadsheet skills in Excel classes, explore Microsoft Office training, or discuss training for your team.