30 Advanced Excel Tips for 2026

Excel Champs / Excel Formulas List / Using Greater Than (>) and Equal To (=) Operator in Excel
By Puneet Gogia (Microsoft MVP)

Using Greater Than (>) and Equal To (=) Operator in Excel

30+ Advanced Excel Tips for 2026

No spam. Only Excel Stuff. God Promise. 😊

The greater-than-or-equal-to operator in Excel is >=, typed as two characters with the angle bracket first. Use it directly to compare: =A1>=B1 returns TRUE when A1 is at least as large as B1, and FALSE otherwise.

On its own, > tests greater than only, and = tests equality — so =4>=3 and =4>3 both return TRUE, while =4=3 returns FALSE. For a readable result instead of TRUE/FALSE, wrap it in IF: =IF(A1>=B1,"Pass","Fail").

Inside functions that take criteria, the operator goes in double quotes and joins to a cell reference with &: =COUNTIF(A1:A10,">=50") counts values of 50 or more, and =COUNTIF(A1:A10,">="&C1) compares against whatever is in C1. That criteria form is where most people actually use it — in COUNTIF, COUNTIFS, SUMIF, SUMIFS, and AVERAGEIF.

The operators also work on dates and text: dates compare as numbers, and text compares alphabetically without regard to case.

You can use the greater than or equal to operator in Excel to test a logical condition.

  • Greater Than: >
  • Equal To: =
  • Greater Than or Equal To: (>=)
greater-than-equal-to-symbols

And in this tutorial, we will look at examples to understand this.

Write a Formula using Greater Than or Equal To

  1. Enter = in a cell to start the formula.
  2. Enter the first value or refer to the cell.
  3. Enter (>=).
  4. Enter the second value or refer to the cell.
  5. Hit enter to get the result.
formula-using-greater-than-and-equal-to

While using the greater than or equal to operator, you must first refer to the value you want to test. In the above example, we have tested 4, so we have referred to it first.

=4>=3

This formula returns TRUE, as 4 is greater than 3. And if both values are the same, like =3>=3, it still returns TRUE, because of the “equal to” part.

Only Greater Than (>)

The greater than operator in Excel is the same one you use in your mathematical calculations. You can enter this operator from your keyboard. In the below example, you can see we have a condition to test if 4 is greater than 3, and in the result, we get TRUE.

condition-to-test

And in the result, we have TRUE, which means the condition is TRUE: 4 is greater than 3.

=4>3

Only Equal To (=)

You can also test a condition only with the (=) equal sign. So in the example below, we have (=4=3) where we test if 4 equals 3.

condition-to-test-with-only-equal-to

In the result, we have FALSE as 4 is not equal to 3.

=4=3

Use Greater Than or Equal To with IF

In real life, you will use this operator inside other functions. With IF, you can return your own result instead of TRUE or FALSE. In the following formula, if the score in B1 is 50 or more, it returns “Pass”, otherwise “Fail”:

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

Use Greater Than or Equal To with COUNTIF and SUMIF

In COUNTIF, SUMIF and similar functions, you need to write the operator as text inside double quotes. The first formula counts the values in B1:B5 that are 50 or more, and the second one adds them up:

=COUNTIF(B1:B5,">=50")
=SUMIF(B1:B5,">=50")

And when the value to compare is in a cell, join the operator and the cell with an ampersand (&):

=COUNTIF(B1:B5,">="&B2)

Compare Dates, Text and Blank Cells

Greater than or equal to works with more than numbers, but there are a few things to keep in mind:

  • Dates: dates are numbers in Excel, so a later date is greater than an earlier one. To use a date directly in a formula, use the DATE function (formula below this list).
  • Text: text is compared in alphabetical order, and the comparison isn’t case-sensitive, so “a” and “A” count as equal.
  • Numbers stored as text: Excel treats any text as greater than any number, so a cell with “10” stored as text returns TRUE for >=100. Convert the text to a number first.
  • Blank cells: a blank cell counts as 0, so a blank cell returns TRUE for >=0.
=DATE(2024,5,1)>=DATE(2024,4,30)

Other Comparison Operators

Apart from greater than or equal to, Excel has less than (<), less than or equal to (<=) and not equal to (<>). They all work the same way and return TRUE or FALSE.

Frequently Asked Questions

Can I type the ≥ symbol in an Excel formula?

No. Excel doesn’t understand the ≥ symbol as an operator. In formulas, always type the two characters >= (greater than sign first, then equal sign).

Why does my formula return TRUE for a text value?

Excel treats text as greater than any number. If your numbers are stored as text, convert them to numbers (for example, with VALUE or Text to Columns) before comparing.

Is >= the same as =>?

No. Excel only accepts >=. If you type =>, Excel shows an error and doesn’t accept the formula.

Puneet Gogia

Written by

Puneet Gogia

Microsoft MVP — Excel · Founder, Excel Champs

Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.

3M+ readers helped
1,000+ tutorials written
Since 2015 teaching Excel

Leave a Comment