In **Excel**, the logical operator “greater than or equal to” is used to collate two data cells of matching data type. The sign “**>=**” is used to indicate the greater than equal to operator. In this article, we will have a look at some examples of using greater than or equal to operator in excel formula and learn how we actually use this operator in our worksheet.

**Table of Contents**hide

**Download Practice Workbook**

You can download the workbook and practice with them.

**7 Examples of Using Greater Than or Equal to Operator in Excel Formula**

**Excel logical operator** helps us to simplify our work. We can easily compare two or more values with those operators. Let’s have a glance at some examples of excel greater than or equal to operator.

**1. Simple Formula with Greater Than or Equal to Operator**

We can use the simple formula operator to compare two numbers. Hence, we are going to use the dataset below. The dataset contains some students’ names in column **B**, their marks in column **C**, and we will compare their marks with the pass mark. If their marks are greater than or equal to the pass mark **33**, only then it will show **TRUE** in column **D**, otherwise, it will show **FALSE**. So, let’s take a look at the steps of how we can use the operator in excel.

**STEPS:**

- Firstly, select cell
**D5**, where we wish to see if the student is passed or not. - Secondly, write down the simple formula with the “
**>=**” operator.

`=C5>=33`

- In cell
**D5**, we can see that the result is**TRUE**. Cause it matches the condition.

- Now, drag the
**Fill Handle**down to see every student’s results.

- Finally, we can view that who didn’t pass the exam.

**2. Greater Than or Equal to Operator with IF Function**

To make the result more specific, now we will use the** IF **function. We are using the same dataset as before. At this point, column **D **will unfold with the result **Pass **or** Fail**. If the marks fulfill the condition, means if the marks are greater than or equal to the pass mark **33**, only then it will view as **Pass**. Now, the steps are listed down.

**STEPS:**

- Likewise, in the above example, select the cell where the result will be shown. So, we choose cell
**D5**. - After that, we compared the pass mark with their marks. So we need to take the marks column in the formula. Now, write down the formula below.

`=IF(C5>=33,"Pass","Fail")`

- Again, drag the
**Fill Handle**over cell**D10**.

- In the end, the result is in column
**D**. And we can easily keep on track those who are failed the exams.

**Read more:** **How to Apply ‘If Greater Than’ Condition In Excel**

**3. Using COUNTIF Function with Greater Than or Equal to Operator**

The **COUNTIF **function will count the number of cells with the conditional operator (“**>=**”). Let’s demonstrate the steps down.

**STEPS:**

- First, select the cell where you want to see the result.
- Next, open the
**COUNTIF**function and select the range**C5:C10**. - After that, write down the formula below.

`=COUNTIF(C5:C10,">="&DATE(2022,2,1))`

- Press
**Enter**to see the result.

We use the **DATE **function to compare data in the date column. The date is **01-02-2022**, so if the date of the sale is greater than or equal to the dates it will count the dates. And the result is **4**.

**4. Greater Than or Equal to Operator with SUMIF Formula**

The **SUMIF** function will sum up the total sales number if it is greater than or equal to **30**. The **SUMIF **function is helpful to sum the total numbers with conditions. Let’s testify to the steps on how we can use the **SUMIF **function.

**STEPS:**

- In the first place, select the cell where we want to view the total number of sales.
- Afterward, exposed to the
**SUMIF**function in that selected cell. - Next, take the cell range
**D5:D10**which we wish to sum up. - Now, write down the formula below.

`=SUMIF(D5:D10,">="&30,D5:D10)`

- Then press
**Enter**for the result.

To compare the number with the total sale number, use the “**&**” before writing off compared number.

**Read More:** **‘Not Equal to’ Operator in Excel (With 5 Examples)**

**5. Excel OR Formula with Greater Than or Equal to Operator**

We use **OR **function to compare more than two numbers. To compare the numbers using greater than or equal to operator, we use the dataset below which contains some students’ names with their marks on **English **and **Mathematics**. Now, if the pass marks match any of the marks then the student will consider as **Pass **in the exam.

**STEPS:**

- In the beginning, select the resulting cell
**E5**. - Now, address the formula below on that cell.

`=OR(C5>=33,D5>=33)`

- Hit
**Enter**.

- After that, drag the
**Fill Handle**down.

- Finally, if the students any of the subject marks meet the condition then it will return
**TRUE**, otherwise**FALSE.**

**Read More:** **How to Perform Greater than and Less than in Excel (5 Methods)**

**6. Apply AND** **Formula Using Greater Than or Equal to Operator**

This time, we are using the dataset above. In this example, we will use the **AND **function to compare the marks with the pass marks. If both subjects marks meet the criteria only then the student can pass the exam.

**STEPS:**

- First of all, pick the resulted cell
**E5**. - Now, write down the below formula and press
**Enter**.

`=AND(C5>=33,D5>=33)`

- After that, drag the
**Fill Handle**down to the cells.

- In the end, It returns
**TRUE**if it fulfills the**AND**function condition, or else**FALSE**.

**Read More:** **How to Use Less Than Or Equal to Operator in Excel (8 Examples)**

**7. Comparing Text Values in Excel Formula with Greater Than or Equal to Operator**

In this example, we will look up how does the greater than or equal to operator works on text values. If the text values are capital that means it is the greater value. Also excel contemplate the earlier letter on the alphabet is smaller and the later alphabets are larger.

**STEPS:**

- As before, select cell
**D5**. - Write the formula down and hit
**Enter**.

`=B5>=C5`

- We can write the text directly using “ ”. For example,
**“Ali”>=“ali”**. And it will return**TRUE**. - Now, drag the
**Fill Handle**down.

- In the end, finally, we will allow to see the result.

**Things to Remember**

- Arithmetic, comparison, text concatenation, and reference are the four types of operators.
- Greater than or equal to (“
**>=**”) is a comparison operator. - It returns the value “
**True**” if greater than equal to condition is met, otherwise “**False**”.

**Conclusion**

The above examples are guidelines to use greater than or equal to operator. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the **ExcelDemy.com** blog!