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 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 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.
Assume we have a numerical value from cell A1 to A5.
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.
Now select the testing cell.
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.
Ok, this what the simple test we are conduction, now press enter key to close the formula. Copy and paste to remaining cells.
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 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 (>=).
Now see the result in cell B4, we got TRUE as the 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’s. Logical operators with IF excel condition is the best combination ever in excel. For an example look at the below example.
From the above data if the sales value is greater than 6500 then we need to calculate 10% incentive amount or else 0% incentive amount.
Step 1: Open IF condition first.
Step 2: Now apply the logical test. i.e. B2 > 6500.
Step 3: If the logical test is TRUE then we need the calculation as B2 * 10% incentive.
Step 4: If the logical test is FALSE then we need the calculation as 0.
Step 5: Now drag and drop the formula to other cells.
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 these operator symbols with COUNTIF in excel as well. Assume below is the data set we have.
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.
Now select the range as date column.
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 DATE excel function. Before that, we need to supply the >= in double-quotes.
Now with an ampersand sign (&) supply the DATE with DATE function.
Now close the formula and hit the enter key.
So, totally 7 invoices are 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.
With this data, we need to sum the sales column if the value is >= 20. Apply SUMIF function to SUM values.
Open SUMIF function first.
Select the range as the Sales column.
Now mention the criteria as “>=”&20.
Now select the sum range as Sales column only.
So, the total value of sales column >=20 is 132.
Things to Remember
- In 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.
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 –