Logical Operators


Logical Operators that can be used in Microsoft Excel

The following is a list of logical operators that you can use in your formulas:

OperatorDescriptionExplanation & Example
>Greater thanEvaluates if a number is greater than another number.

=(2>1)=TRUE
>=Greater than or equal toEvaluates if a number is greater than or equal to another number, when using the "less than" and "equals" symbols together.

=(2>=1)=TRUE
=(1>=1)=TRUE
=(0>=1)=FALSE
<Less thanEvaluates if a number is less than another number.

=(1<2)=TRUE
<=Less than or equal toEvaluates if a number is less than or equal to another number, when using the "greater than" and "equals" symbols together.

=(2<=1)=FALSE
=(1<=1)=TRUE
=(0<=1)=TRUE
=Equal toEvaluates if 2 numbers are equal.

=(4=2)=FALSE
=(2=2)=TRUE
<>Not equal toEvaluates if 2 numbers are not equal, when using the "less than" and "greater than" symbols together.

=(4<>2)=TRUE
=(2<>2)=FALSE

 

Go back to Excel Tutorials.