Google Sheets: Use Greater Than or Equal to in IF Function

You can use the >= operator in Google Sheets to check if a value in a given cell is greater than or equal to some value.

To use this operator in an IF function, you can use the following syntax:

`=IF(C2>=20, "Yes", "No")`

For this particular formula, if the value in cell C2 is greater than or equal to 20, the function returns “Yes.”

Otherwise it returns “No.”

The following examples show how to use this syntax in practice.

Example: Using Greater Than or Equal to in IF Function in Google Sheets

We can type the following formula into cell C2 to return “Yes” if the number of points in cell B2 is equal to or greater than 20:

`=IF(C2>=20, "Yes", "No")`

We can then drag and fill this formula down to each remaining cell in column C:

The formula returns either “Yes” or “No” in each row depending on whether or not the points value in column B is greater than or equal to 20.

Note that you can also use the greater than or equal to sign (>=) to compare the value in two cells.

For example, suppose we have the following dataset that shows the number of points scored and allowed by various basketball players:

We can type the following formula into cell D2 to return “Yes” if the number of points in cell B2 is equal to or greater than the number of points allowed in cell C2:

`=IF(B2>=C2, "Yes", "No")`

We can then drag and fill this formula down to each remaining cell in column D:

The formula returns either “Yes” or “No” to indicate if the points scored in column B is greater than or equal to the corresponding points allowed in column C.