Comparison Operators in Excel - Easy Explanation of Each Operator with Examples

Comparison operators in Excel compare two values, and as a result, produce a logical value either TRUE or FALSE. They are generally used with logical functions (IF, AND, OR, etc.) when setting or checking a condition. There are 6 comparison operators in Excel: equal sign, greater than sign, less than sign, greater than or equal to sign, less than or equal to sign and not equal to sign.

In this tutorial, you'll learn about comparison operators in Excel and see how they are used in formulas.

[invenew]

Outstanding tutorial!! please could we count the numbers Ex. ">20>80" in one column i:e C:C at once ( ( by counif(s)) function...I mean could we use "<6<13" to count the numbers only those less than 6 and less than 13Thanx in Advance