The Logic Test
Excel's logic functions always involve a comparison between two values. The logic test can only return a true or false answer, depending on the condition tested.
The Comparison Operators
The comparison operators that can be used in a logic test are:
Equals ( = )
Less than ( < )
Less than or equal to ( < = )
Greater than ( > )
Greater than or equal to ( > = )
Not equal to ( < > )
Examples
The logic test can be a comparison between two cell references such as:
A3 > B3
Or the logic test can be a comparison between a cell reference and a fixed amount such as:
C4 < = 100
