Sabrina Ayon
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.
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.
