Excel Logical Operators: How To Do Greater Than or Equal To in Excel

Last updated: August 18, 2026.

Quick answer: In Excel, greater than or equal to is written >=. Use =A1>=B1 for a TRUE or FALSE result, =IF(A1>=50,"Pass","Fail") for conditional logic, and =COUNTIF(B2:B20,">=100") to count. Inside COUNTIF, SUMIF and SUMIFS the operator must sit inside quotation marks, and a cell reference is joined with ">="&A1.

On this page

• What are Excel's comparison operators?
• How do you type the greater than or equal to symbol in Excel?
• What does the >= operator actually do?
• How do you use >= inside an IF function?
• How do you test a range, greater than X and less than Y?
• How do you use >= in COUNTIF, SUMIF and SUMIFS?
• How do you use a cell reference as the threshold?
• How do you compare dates with >=?
• How does >= work on text?
• How do you apply conditional formatting with >=?
• What is GESTEP, and how is it different from >=?
• Why does >= fail on numbers stored as text?
• FAQ

What are Excel's comparison operators?

Excel has six comparison operators. Each one compares two values and returns TRUE or FALSE, and each one can be used on its own, inside IF, or as a criterion in COUNTIF and SUMIF. Microsoft lists the full set in its calculation operators and precedence reference.

Rule to remember: in a formula the operator stands alone, in a criterion it goes inside quotation marks. That single difference causes most of the errors on this page.

If your comparison needs to ignore empty cells first, pair the operator with an IF not blank formula, which covers ISBLANK, blank criteria and the non-blank side of the same problem.

How do you type the greater than or equal to symbol in Excel?

You type two characters, the greater-than sign and the equals sign, in that order: >=. There is no special key and no autocorrect step. Typing => the other way round produces a formula error, so the order matters.

The mathematical symbol ≥ is a different thing. Excel does not accept it in a formula. You can insert it as a label using Insert > Symbol, or by typing 2265 and pressing Alt and X in a text box, but it is display only.

Rule to remember: >= is for formulas, ≥ is for labels, and they are not interchangeable.

What does the >= operator actually do?

The >= operator is a logical comparison. It evaluates whether the value on the left is greater than or equal to the value on the right and returns TRUE or FALSE. The syntax is:

=A1>=B1

If the first value is greater than or equal to the second, the formula returns TRUE. Otherwise it returns FALSE.

TRUE and FALSE are not just labels. Excel treats TRUE as 1 and FALSE as 0, which is why =SUMPRODUCT(--(A2:A20>=50)) counts how many values clear a threshold without needing COUNTIF at all.

Rule to remember: a bare comparison returns TRUE or FALSE, and TRUE equals 1 in any arithmetic that follows.

How do you use >= inside an IF function?

The IF function turns that TRUE or FALSE into a result you choose. This is how you grade scores, band sales performance, or approve orders above a minimum.

Example. Assign "Pass" or "Fail" based on a score threshold:

=IF(A1>=50, "Pass", "Fail")

If the value in A1 is greater than or equal to 50, the result is "Pass." Otherwise it is "Fail."

Grading with several thresholds.

Nested IFs read cleanly when you order the thresholds from highest to lowest, because Excel stops at the first test that passes:

=IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C","F")))

Order them the other way round and every score above 70 returns "C," because the first test that passes wins.

Handling empty cells before you compare.

An empty cell reads as 0, so =IF(A1>=0,"OK","Low") returns "OK" for every blank row in the sheet. Guard the comparison:

=IF(A1="","",IF(A1>=50,"Pass","Fail"))

Rule to remember: order nested thresholds from highest to lowest, and test for blank before you test for a value.

How do you test a range, greater than X and less than Y?

Excel has no BETWEEN function. You combine two comparisons with AND:

=IF(AND(A1>=10,A1<=20),"In range","Out of range")

AND returns TRUE only when both tests pass, so this covers 10 through 20 inclusive. Use > and < instead of >= and <= if you want to exclude the endpoints.

For the counting and summing equivalents, stack two criteria in COUNTIFS or SUMIFS:

=COUNTIFS(B2:B100,">=10",B2:B100,"<=20")

=SUMIFS(C2:C100,B2:B100,">=10",B2:B100,"<=20")

Notice that the same range is listed twice, once for each end of the band. That is correct and expected.

Rule to remember: a between test is two comparisons joined by AND, or the same range listed twice in COUNTIFS.

How do you use >= in COUNTIF, SUMIF and SUMIFS?

In these functions the comparison is not a formula, it is a text criterion. The whole thing, operator and number together, goes inside quotation marks. The SUMIF and COUNTIF functions both work this way.

Count values at or above a threshold:

=COUNTIF(B2:B6, ">=100")

Sum values at or above a threshold:

=SUMIF(B2:B6, ">=100")

Sum a different column from the one you test:

=SUMIF(B2:B100,">=100",C2:C100)

Here SUMIF looks at column B, keeps the rows at or above 100, and adds the matching values from column C.

Stack multiple conditions with SUMIFS:

=SUMIFS(C2:C100,B2:B100,">=100",A2:A100,"West")

SUMIFS reverses the argument order. The range you are adding comes first, then each pair of criteria range and criterion. Mixing the two orders up is the second most common error in this whole topic.

Rule to remember: SUMIF puts the sum range last, SUMIFS puts it first.

How do you use a cell reference as the threshold?

This is where nearly everyone gets stuck. You want the threshold to live in a cell so you can change it without editing formulas. The obvious attempt fails:

=COUNTIF(B2:B100,">=A1") returns 0, because Excel reads it as the literal text "greater than or equal to the letters A1."

The criterion is text, so you have to build the text. Join the operator to the cell reference with the ampersand:

=COUNTIF(B2:B100,">="&A1)

The operator stays inside quotation marks, the cell reference stays outside, and & glues them together. The same pattern works everywhere a criterion is accepted:

Rule to remember: ">="&A1 works, ">=A1" never does.

How do you compare dates with >=?

Excel stores dates as serial numbers, so date comparisons are really number comparisons. That makes >= work exactly as you expect, provided the values are genuine dates.

Is this date on or after a deadline?

=IF(A2>=DATE(2026,1,1),"On time","Late")

Wrapping the date in DATE avoids the regional format problem. Typing =A2>="01/02/2026" compares a date to a text string, which gives the wrong answer on a US system and a different wrong answer on a UK one.

Is this date today or later?

=IF(A2>=TODAY(),"Upcoming","Past")

Count records from the last 30 days:

=COUNTIF(A2:A100,">="&TODAY()-30)

Sum invoices dated on or after a date in a cell:

=SUMIF(A2:A100,">="&E1,B2:B100)

If a date comparison returns an answer that makes no sense, the values are probably text. Test with =ISNUMBER(A2). If it returns FALSE, the cell holds text that looks like a date, and no comparison operator will treat it correctly until you convert it.

Rule to remember: a real date returns TRUE from ISNUMBER, and anything that does not is text pretending to be a date.

How does >= work on text?

Excel compares text alphabetically, so "Apple" is considered less than "Banana." The comparison is not case sensitive, which means "apple" and "APPLE" are treated as equal.

Example: check whether a name falls at or after "John" alphabetically:

=A1>="John"

This returns TRUE for any name from John onward in the alphabet.

One thing to watch: in Excel's sort order, any text is greater than any number. So ="apple">=999999 returns TRUE. If a column mixes numbers and text, comparisons will produce results that look wrong until you split the data types apart.

Rule to remember: text comparison is alphabetical and case insensitive, and every text value outranks every number.

How do you apply conditional formatting with >=?

Conditional formatting uses the same operator to colour cells instead of returning text.

• Select the range of cells you want to format.

• Go to Home > Conditional Formatting > New Rule.

  

• Choose Use a formula to determine which cells to format.

• Enter the formula, for example =A1>=DATE(2026,1,1) to highlight dates on or after a deadline.

  

• Set the formatting you want, such as bold text or a coloured background, and click OK.

  

Two details decide whether the rule behaves. Write the formula for the top-left cell of your selection, because Excel shifts the reference across the rest of the range. And lock the column with a dollar sign, as in =$B1>=100, when you want the whole row to react to one column's value.

For more rule patterns, see our guide to conditional formatting based on another cell.

Rule to remember: a conditional formatting formula is written for the first cell in the selection, then copied outward automatically.

What is GESTEP, and how is it different from >=?

GESTEP is an engineering function that tests whether a number is greater than or equal to a step value. Its syntax is =GESTEP(number, [step]), and it returns 1 or 0 rather than TRUE or FALSE. If you leave the step out, it defaults to 0.

=GESTEP(A1,50) and =--(A1>=50) return the same 1 or 0. Because GESTEP already gives you a number, it adds up directly: =SUMPRODUCT(GESTEP(A2:A20,50)) counts how many values clear 50.

Rule to remember: use >= for anything you will read, and GESTEP only when you want a 1 or 0 you can add up.

Why does >= fail on numbers stored as text?

This is the most common reason a correct-looking comparison returns the wrong answer. Numbers imported from a database, a CSV, or a web page often arrive as text. They sit on the left of the cell instead of the right, and they frequently carry a small green triangle in the corner.

Because Excel ranks all text above all numbers, a text "45" is greater than the number 1,000,000. So =A1>=100 returns TRUE on a text "45," and =COUNTIF(A2:A100,">=100") skips the text values entirely and returns a count that is too low. The two symptoms often appear on the same sheet, which is why the problem is confusing.

How to confirm it.

Put =ISNUMBER(A2) next to the suspect cell. FALSE means the value is text. =ISTEXT(A2) returning TRUE confirms the same thing from the other side.

How to fix it.

1. The fastest fix: select the range, click the warning triangle, and choose Convert to Number.
2. The bulk fix: type 1 in an empty cell, copy it, select the text numbers, then use Paste Special > Multiply. Multiplying by 1 forces Excel to re-evaluate every value as a number.
3. The formula fix: use =VALUE(TRIM(A2)) in a helper column, then paste the results back as values.
4. The import fix: reimport with Power Query and set the column type to Whole Number or Decimal so the problem never enters the sheet.

Watch for the invisible causes too: a trailing space, a thousands separator that does not match your regional settings, or a non-breaking space at character 160 copied from a web table. =VALUE(SUBSTITUTE(TRIM(A2),CHAR(160),"")) handles all three at once.

Our guide to converting text to numbers in Excel walks through each method in detail.

Rule to remember: if ISNUMBER returns FALSE, every comparison on that cell is unreliable until you convert it.

Common pitfalls and quick checks

1. Operator order. It is >=, never =>. The reversed version returns an error.
2. Criteria quoting. In COUNTIF and SUMIF the operator goes inside quotation marks, and a cell reference is joined with &.
3. Blank cells read as zero. A test like >=0 passes on every empty row unless you check for blank first.
4. Data type mismatches. Compare numbers with numbers and dates with dates. ISNUMBER tells you which you have.
5. Argument order. SUMIF ends with the sum range, SUMIFS begins with it.
6. Hidden characters. Trailing spaces and non-breaking spaces silently turn numbers into text.

Final thoughts

The >= operator itself takes a minute to learn. Everything difficult about it comes from context: the criterion has to be a text string in COUNTIF and SUMIF, a cell reference has to be joined with an ampersand, blanks read as zero, and text numbers break comparisons without any error message to warn you. Get those four right and the operator does the rest.

For more easy-to-follow Excel guides and the latest Excel Templates, visit Simple Sheets and the related articles section of this blog post.

Subscribe to Simple Sheets on YouTube for the most straightforward Excel video tutorials.

FAQ

How do you write greater than or equal to in an Excel IF function?

Put the operator directly in the logical test, as in =IF(A1>=50,"Pass","Fail"). No quotation marks are needed around the comparison inside IF, unlike COUNTIF and SUMIF where the whole criterion must be quoted.

Why does my COUNTIF with a cell reference return 0?

Because ">=A1" is read as literal text. Join the operator to the reference with an ampersand instead: =COUNTIF(B2:B100,">="&A1). The operator stays in quotation marks, the cell reference stays outside them.

Why is my >= formula not working with dates?

The dates are probably text rather than real date values. Confirm with =ISNUMBER(A2). If it returns FALSE, convert the column to dates first. Also wrap fixed dates in the DATE function, as in =A2>=DATE(2026,1,1), so regional date formats cannot change the result.

How do I write greater than X and less than Y in Excel?

Excel has no BETWEEN function, so combine two comparisons with AND: =IF(AND(A1>=10,A1<=20),"In range","Out of range"). For counting and summing, list the same range twice in COUNTIFS or SUMIFS, once for each end of the band.

What is the difference between GESTEP and the >= operator?

GESTEP returns 1 or 0 while >= returns TRUE or FALSE. GESTEP only accepts numbers and defaults to comparing against 0 when the step is omitted. Use >= for everyday comparisons and GESTEP when you want a numeric result you can add up directly.

Why does my greater than or equal to comparison give the wrong answer?

The most likely cause is numbers stored as text. Excel ranks any text above any number, so a text value passes a numeric threshold test while COUNTIF ignores it completely. Check with =ISNUMBER(A2), then convert with Paste Special Multiply by 1 or the VALUE function.

Can the >= operator be used in array formulas?

Yes. =SUMPRODUCT(--(A1:A10>=50)) counts how many values in the range clear 50, because Excel converts each TRUE to 1 and each FALSE to 0. The same comparison works inside FILTER, SUMPRODUCT and other dynamic array functions.

How do I type the ≥ symbol in Excel?

Formulas use two characters, >=. The single ≥ symbol cannot be used in a formula, but you can insert it as a label through Insert > Symbol, or by typing 2265 and pressing Alt and X inside a text box.

Related Articles

How to Calculate Standard Error in Excel

How to Add Error Bars in Excel

How to Clear Cache in Excel