WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Greater Than or Equal to

Excel Greater Than or Equal to

Excel Greater than or equals to is an operator which is a comparison operator in excel, this operator is used in two different or similar values or cells, the symbol for this operator is as follows >= the first symbol is for greater than and the second symbol is for equals to, this function returns value true if the first value is either greater than or equals to the second value and returns a false value if the first value is smaller than the second value.

Greater Than or Equal to (>=) in Excel

If you are testing numbers in excel and you are not aware of how to express the logical operators like greater than (>), excel greater than equal to (>=), then this article will take a walk through the detailed analysis on ways of using these excel logical operator symbols.

Equal sign (=) is the commonly used mathematical operator symbol in excel. For all most all the formulas, we use equal sign (=). If any calculations are required, we use plus (+), minus (-), multiplication (*), and division (/) symbols as well inside the formula.

However, there are other useful sets of logical operators like greater than and greater or equal to operator symbols. Even though there are many logical operators in this article, we will concentrate only on greater than (>) and greater than or equal to (>=).

How to Use Greater Than (>) & Greater Than or Equal to (>=)?

Now we will see how to use these excel logical operators.

You can download this Greater Than or Equal to Excel Template here – Greater Than or Equal to Excel Template

Assume we have a numerical value from cell A1 to A5.

Example 1

Now I want to test these numbers, whether they are greater than the value of 50.

Let’s open the test with equal sign first.

Example 1-1

Now select the testing cell.

Example 1-2

Now the test is whether the selected cell is greater than 50 or not. So mention the operator symbol greater than (>) and apply the logic as 50.

Example 1-3

Ok, this what the simple test we are conduction; now press the enter key to close the formula. Copy and paste to remaining cells.

Example 1-4

All the yellow-colored cells have a value greater than 50, so we got the result of the formula as TRUE. But in the cell A4, even though the value is 50, the result is FALSE. The reason is because of the operator symbol; we mentioned only greater than (>). In order to include 50 also in this range, we need to supply the formula as greater than (>=).

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1-5

Now see the result in cell B4; we got TRUE as a result. This is the basic idea of operator symbols in excel.

In the next sections, we will see how to use these greater than and excel greater than or equal to (>=) operator symbols in other formulas.

Greater Than & Excel Greater Than or Equal to (>=) in Other Formulas

Example #1 – Excel Greater than or equal to (>=) With IF Condition

With the help of these logical operator symbols, we can actually draw so many useful information. Logical operators with IF excel condition is the best combination ever in excel. For example, look at the below example.

Equal to with If Step 1

From the above data, if the sales value is greater than 6500, then we need to calculate a 10% incentive amount or else 0% incentive amount.

Step 1: Open the IF condition first.

Equal to with If Step 2

Step 2: Now, apply the logical test. i.e. B2 > 6500.

Equal to with If Step 3

Step 3: If the logical test is TRUE, then we need the calculation as B2 * 10% incentive.

Equal to with If Step 4

Step 4: If the logical test is FALSE, then we need the calculation as 0.

Equal to with If Step 5

Step 5: Now drag and drop the formula to other cells.

Equal to with If Step 6

Since the values in the cells B5, B11, B12, and B13 are greater than 6500, we got the incentive calculation in respective cells.

Example #2 – Excel Greater than or equal to (>=) With COUNTIF Condition

We have seen the combination of IF with greater than (>) symbol. We can use these operator symbols with COUNTIF in excel as well. Assume below is the data set we have.

Equal to with COUNTIF Step 1

From the above data, I want to count how many invoices are sent on or after 14th March 2019.

When you say on or after 14th March 2019, this is nothing but >=14-03-2019. Let’s apply the COUNTIF function now.

Equal to with COUNTIF Step 2

Now select the range as a date column.

Equal to with COUNTIF Step 3

Now the criteria will be >=14-03-2019. Since we don’t cell reference for the date here, we need to supply the date with the DATE excel function. Before that, we need to supply the >= in double-quotes.

Equal to with COUNTIF Step 4

Now with an ampersand sign (&), supply the DATE with DATE function.

Equal to with COUNTIF Step 5

Now close the formula and hit the enter key.

Equal to with COUNTIF Step 6

So, a total of 7 invoices is generated on or after 14th March 2019.

Example #3 – Excel Greater than or equal to  (>=) With SUMIF Condition

We can also use >= operator sing with SUMIF excel condition. Assume below is the data we are working on.

Equal to with SUMIF Step 1

With this data, we need to sum the sales column if the value is >= 20. Apply SUMIF function to SUM values.

Open the SUMIF function first.

Equal to with SUMIF Step 2

Select the range as the Sales column.

SUMIF Step 3

Now mention the criteria as “>=”&20.

SUMIF Step 4

Now select the sum range as Sales column only.

SUMIF Step 5

So, the total value of sales column >=20 is 132.

Things to Remember

  • In the IF condition, you need to supply logical operators with double-quotes.
  • In COUNTIF, SUMIF, and IFS conditions, we need to supply the logical operators with double-quotes.
  • The result of logical operators is always either TRUE or FALSE.

Recommended Articles

This has been a guide to Greater than or equal to in Excel. Here we discuss How to Use Greater Than and Excel Greater Than or Equal to (>=) with IF, SUMIF, and COUNTIF Formulas along with examples and downloadable excel templates. You may also look at these useful functions in excel –

  • “Not Equal” in VBA
  • Excel Formula for COUNTIF
  • Not Equal to in Excel
  • List of Excel Functions
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Greater Than or Equal to Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More