GREATER THAN Operator (>) - Excel
Overview
The Greater than operator (>) in Excel is a useful tool for comparing two values. This operator allows users to check if one value is greater than another.
Syntax:
=expression1 > expression2
expression1 and expression2 can be cell references, values, or more complex expressions.
Example: TRUE value
In this example, the Greater than operator is comparing two different values and returns a TRUE result. Cell C2 equals 10 and cell D2 equals 5 so the Greater than operator returns a TRUE value because 10 is greater than 5.
Example:
=C2 > D2
Example: FALSE value
In this example, the Greater than operator is comparing two different values and returns a FALSE result. Cell C2 equals 7 and cell D2 equals 10 so the Greater than operator returns a FALSE value because 7 is not greater than 10.
Example:
=C2 > D2