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 the greater than or equal to operator in the Excel formulas and learn how we actually use this operator in our worksheet.

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.

**Table of Contents**hide

## 1. Creating a Simple Formula with the 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**, and 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 those who didn’t pass the exam.

**Read More:** **How to Use Less Than Or Equal to Operator in Excel**

## 2. Applying Greater Than or Equal to Operator with IF Function

To make the result more specific, 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 be viewed 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 marks 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 the 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. Applying 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 in summing 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 the compared number.

**Read More:** **‘Not Equal to’ Operator in Excel**

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

We use the **the 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**

## 6. Applying AND Formula with 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 resulting 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**.

## 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 of 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 be able 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 the condition is met, otherwise “**False**”.

**Download Practice Workbook**

You can download the workbook and practice with them.

**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.