How to Write Greater Than or Equal To in Excel IF Function

The IF function in Excel is a logical function where you may need to use various comparison operators: equal, not equal, greater than, less than, and so on. Today we are going to show you how to use greater than or equal to in IF function. For this session, we are using Excel 2019, feel free to use yours.

First things first, let’s get to know about today’s practice workbook.

Dataset - How to Write Greater Than or Equal To in Excel IF Function

Here we have several students with their respective scores on a couple of tests. We will use this dataset to write greater than or equal to in the IF function.

Note that, it is a basic table with a dummy dataset. In real-life scenarios, you may encounter a much complex and larger dataset.

Practice Workbook

You are welcome to download the practice workbook from the link below.

Greater Than or Equal To in IF Function

Let’s begin the journey to see how to use greater than or equal to in IF. Unless you have not known about the IF function, please visit this IF article.

1. Greater Than

For a quick note let’s get to know the use of the Greater Than operator first. For example, we will check whether Test 1 score is higher than Test 2 score for each student.

Here we will use the formula written below

=IF(D4>E4, "Score higher in Test 1","Test 1 Score not highest")

D4 is Test 1 and E4 is Test 2 score respectively for the first student. And we have set “Score higher in Test 1” at the if_true_value field and “Test 1 Score not highest” at the if_false_value field.

Greater than formula result - How to Write Greater Than or Equal To in Excel IF Function

Here for the first student Test 1 score is greater than Test 2 score. And that’s why we have found the if_true_value as our result.

For the second student also we should find the if_true_value but you can see the third student’s scores are equal (no one is lower, no one is higher). What should be the output for that?

Our logical test for this student is not TRUE since Test 1 is not greater so it will return the if_false_value.

Greater than formula result 2 - How to Write Greater Than or Equal To in Excel IF Function

You can see in the image for the third student we have found “Test 1 Score not highest” which is the if_false_value in our formula.

Similarly, for the fourth student, we will find the if_false_value.

Greater than formula result 3- How to Write Greater Than or Equal To in Excel IF Function

Now write the formula for the rest of the values or simply exercise the Excel AutoFill feature.

Greater than operator Autofill - How to Write Greater Than or Equal To in Excel IF Function

2. Equal To

In this section, we will see how to use the Equal To operator within the IF function. Our base of example is going to be the same as the previous section, only the formula will be different.

To compare whether Test 1 and Test 2 scores are the same (equal) or not, we will use the formula written below

=IF(D4=E4, "Score same in both tests","Scores are not same")

D4 is Test 1 and E4 is Test 2 score respectively for the first student. And we have set “Score same in both tests” at the if_true_value field and “Scores are not same” at the if_false_value field.

Equal to result - How to Write Greater Than or Equal To in Excel IF Function

Since the scores of the first student are not equal, we have found the if_false_value. For the second student also we will find the if_false_value (Scores are not the same)

Equal to operator result - How to Write Greater Than or Equal To in Excel IF Function

You can see the scores of the third student are equal (it is a small dataset so you can understand at a glance), and our formula will provide the if_true_value (Score same in both tests) 

Equal to operator result 2 - How to Write Greater Than or Equal To in Excel IF Function

Now do the same for the rest of the values or exercise the AutoFill feature.

Equal to operator Autofill - How to Write Greater Than or Equal To in Excel IF Function

3. Greater Than or Equal To

Now we are at the business end of our tutorial, we are going to see how to Greater Than or Equal To operator.

I. Apply on Numbers

In this section, we will see how we can apply the operator to numeric values. Let’s begin.

At first, we will compare whether the score in Test 1 is greater than or equal to the score in Test 2 or not.

Check column - How to Write Greater Than or Equal To in Excel IF Function

And our formula will be

=IF(D4>=E4,"Greater or Equal","Lesser")

Here we have set “Greater or Equal” at the if_true_value field and “Lesser” at the if_false_value field.

Greater than or Equal to result - How to Write Greater Than or Equal To in Excel IF Function

Test 1 score for the first student is greater than his Test 2 score, so it returns TRUE and our result here is “Greater or Equal” (if_true_value).

If the listed scores are equal, then also the formula will return the if_true_value.

Greater than or Equal to result 2- How to Write Greater Than or Equal To in Excel IF Function

Here the third student scored 6 on both the tests and our formula returned Greater or Equal.

When the score in Test 1 is lower than the score in Test 2, we will find the if_false_value. 

Greater than or Equal to result 3- How to Write Greater Than or Equal To in Excel IF Function

Student Jija scored 9 and 10 in Test 1 and Test 2 respectively, and our formula provided if_false_value (Lesser).

Write the formula for the rest of the values.

Greater than or Equal to Autofill - How to Write Greater Than or Equal To in Excel IF Function

We can compare whether the score in Test 2 is greater than or equal to the score in Test 1 or not.

Check 2 - How to Write Greater Than or Equal To in Excel IF Function

Our formula will be similar, all we need to do is interchange the Cell Reference of the two scores.

=IF(E4>=D4,"Greater or Equal","Lesser") 

Since the first student scored lesser in Test 2 than Test 1 the logic will return FALSE and the formula will return the if_false_value (Lesser).

Greater than or equal to result 4 - How to Write Greater Than or Equal To in Excel IF Function

When the values are equal or Test 2 is greater we will find Greater or Equal as result.

Greater than or equal to result 5 - How to Write Greater Than or Equal To in Excel IF Function

For the rest of the values write the formula or use the AutoFill feature.

Greater than or equal to AutoFill 2 - How to Write Greater Than or Equal To in Excel IF Function

II. Apply on Texts

We can compare texts to see whether they are greater than or equal or not. For example purpose here we have a table of a couple of items from several shops.

Text dataset - How to Write Greater Than or Equal To in Excel IF Function

Let’s check whether Item 1 is greater than or equal to Item 2. And the formula will be

=IF(C4>=D4,"Greater or Equal","Lesser") 

Greater than or equal to in Text - How to Write Greater Than or Equal To in Excel IF Function

For the first shop, we found the formula result, Lesser which is if_false_value. 

You may wonder how this works, let us help you a bit. Every character has ASCII value, machine (computer) and applications recognize the character with its ASCII value. Here the combined ASCII value of Apple is lower than Banana so we have found the if_false_value. 

When it is the same then we will get TRUE in return and the result will be if_true_value.

Greater than or equal to in Text 2 - How to Write Greater Than or Equal To in Excel IF Function

Similarly, when Item 1 is greater then we will also find the if_true_value (Greater or Equal). 

Greater than or equal to in Text 3 - How to Write Greater Than or Equal To in Excel IF Function

Here ASCII of Banana is higher than the ASCII of Apple, so we have found the if_true_value.

Write the formula for the rest of the values.

Greater than or equal to in AutoFill - How to Write Greater Than or Equal To in Excel IF Function

Conclusion

That’s all for today. We have shown you how to write greater than or equal to in the IF function in Excel. Hope you will find this helpful. Feel free to comment if anything seems difficult to understand. Let us know any other approach to write greater than or equal operators.

shakil

My name’s Shakil. My articles are targeted to support you in enriching knowledge regarding different features related to Microsoft Excel. I am fond of literature, hope some knowledge from them will help me providing you some engaging articles even though some weary technical terms.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo