The less than (<) operator returns TRUE if the first value is less than the second.
1. For example, see the formula in cell C1 below.
Explanation: the formula returns TRUE because the value in cell A1 is smaller than the value in cell B1.
2. The AND function below uses the less than operator.
Greater than or equal to operator
The greater than or equal (>=) operator returns TRUE if the first value is greater than or equal to the second.
1. For example, see the formula in cell C1 below.
2. The COUNTIF function below uses the greater than or equal to operator.
Less than or equal to operator
The less than or equal (<=) operator returns TRUE if the first value is less than or equal to the second value.
1. For example, see the formula in cell C1 below.
2. The SUMIF function below uses the less than or equal to operator.
The operator is not equal to
The not equal (<>) operator returns TRUE if the two values are not equal.
1. For example, see the formula in cell C1 below.
2. The IF function below uses the not equals operator.
In addition, you can also view many other excel articles here.
