GREATER THAN OR EQUAL TO Operator (>=) - Excel
Overview
The Greater than or equal to operator (>=) in Excel is a useful tool for comparing two values. This operator allows users to check if one value is greater than or equal to 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 or equal to operator is comparing two different values and returns a TRUE result. Cell C2 equals 10 and cell D2 equals 5 so the Greater than or equal to operator returns a TRUE value because 10 is greater than or equal to 5.
Example:
=C2 >= D2
Example: FALSE value
In this example, the Greater than or equal to operator is comparing two different values and returns a FALSE result. Cell C2 equals 7 and cell D2 equals 10 so the Greater than or equal to operator returns a FALSE value because 7 is not greater than or equal to 10.
Example:
=C2 >= D2