In Google Sheets, to use the greater than or equal to operator, you need to combine the equal to (=) and greater than (>) operators (>=). In this tutorial, we write a formula with this to learn to use it.
Using >= Greater Than or Equal To
In the below example, we have two numbers in the cell A1 and B1.
- First, in a cell, enter (=) to start the formula.
- After that, refer to cell A1 where we have the first number.
- Now, enter greater than and then equal to sign.
- Next, refer to the cell B1 where you have the second number.
- In the end, hit enter to get the result.
When you use >= operator, which is a logical operator, this returns the result as TRUE or FALSE. And in our example, we are comparing 200 with 230, and 200 is smaller than 230, so we have a FALSE in the result.
Using >= Greater Than or Equal To with the IF Function
You can also use it in the IF function to text a condition.
In the above example, we have used the same condition to test with the greater than or equal to an operator in the logical expression argument.
=IF(A1>=B1,"Yes","No")
=IF(200>=230,"Yes","No")
And when you hit enter, it returns “No” in the result as the condition is FALSE.