Learn how to test whether specific criteria in your spreadsheet is 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) |
Master Microsoft Office
Office is the industry standard for desktop publishing. It offers a full suite of productivity tools and is always adding new features.
We offer the best Microsoft Office training in NYC. Keep up to date and learn how to create engaging presentations, generate reports on the fly, automate tasks, and more! Our expert instructors guide students of all levels through step-by-step projects with real-world applications. Sign up individually, or contact us about corporate training today: