Greater Than or Equal To in Excel: >=, <= and <>
· 12 min read
The greater than or equal to Excel operator is >=: a greater-than sign followed by an equals sign, with no space between them. It compares two values and returns TRUE or FALSE:
=E2>=500That returns TRUE when E2 is 500 or more. Less than or equal to is <=, and "does not equal" is <>. Excel does not accept the single ≥ character in a formula, so always type the two-character version.
How to put greater than or equal to in Excel
In a formula, type > then =. That is the only form Excel understands as an operator.
If you want the ≥ symbol as text, for example in a column header or a label such as "≥ 500 units", you have three options:
- Insert > Symbol, then pick
≥(or≤) from the Mathematical Operators subset. - Keyboard: on Windows, hold Alt and type 242 on the numeric keypad for
≥(243 gives≤). On a Mac with a US layout, press Option and the full stop for≥, Option and the comma for≤. - Formula:
=UNICHAR(8805)returns≥and=UNICHAR(8804)returns≤, so="Orders "&UNICHAR(8805)&" 500"builds the label "Orders ≥ 500".
The symbol is only for display. A formula such as =E2≥500 is not valid, and =COUNTIF(E2:E7,"≥500") looks for cells that contain the literal text "≥500", so it counts nothing.
The comparison operators
Excel has six comparison operators. Each one returns TRUE or FALSE:
| Operator | Meaning | Example with E2 = 500 | Result |
|---|---|---|---|
= | equal to | =E2=500 | TRUE |
<> | not equal to | =E2<>500 | FALSE |
> | greater than | =E2>500 | FALSE |
< | less than | =E2<500 | FALSE |
>= | greater than or equal to | =E2>=500 | TRUE |
<= | less than or equal to | =E2<=500 | TRUE |
The only difference between > and >= is the boundary. A value of exactly 500 passes >=500 and fails >500. That one character decides whether the edge case counts, so match it to the wording of the rule: "at least 500" and "500 or more" mean >=, "over 500" and "more than 500" mean >.
Greater than or equal to in Excel: worked example
Six Brightline Supply Co. orders. Columns F to I each hold one comparison, filled down:
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Order date | Amount | At least 500 | 100 or less | Not West | Size |
| 2 | 50112 | Harbor & Pine Hotels | West | 2025-06-12 | 500.00 | TRUE | FALSE | FALSE | Large |
| 3 | 50287 | River Print Co | West | 2025-06-30 | 499.50 | FALSE | FALSE | FALSE | Standard |
| 4 | 50341 | Lakeside Studios | East | 2025-07-01 | 86.00 | FALSE | TRUE | TRUE | Standard |
| 5 | 50518 | Willow Hotels | North | 2025-07-15 | 1,240.00 | TRUE | FALSE | TRUE | Large |
| 6 | 50602 | Oak Labs | South | 2025-08-04 | 100.00 | FALSE | TRUE | TRUE | Standard |
| 7 | 50777 | Meadow Bakery | East | 2025-09-19 | 312.00 | FALSE | FALSE | TRUE | Standard |
Column F is =E2>=500. It returns TRUE for order 50112 (exactly 500) and order 50518 (1,240), and FALSE for the rest. Order 50287 is 499.50, so it misses by fifty cents.
Column G is the less than or equal to Excel test, =E2<=100. It is TRUE for order 50341 (86) and order 50602 (exactly 100).
Using >= inside IF
A bare comparison returns TRUE or FALSE. To show a label instead, put the comparison in the first argument of IF, as in column I:
=IF(E2>=500, "Large", "Standard")Results: Large, Standard, Standard, Large, Standard, Standard. The comparison can point at another cell instead of a fixed number, for example =IF(E2>=$K$1, "Large", "Standard") with the threshold typed in K1. Our IF with AND and OR guide covers nested IF for three or more labels.
Excel does not equal: <>
<> is the "not equal" operator in Excel. Column H uses it on text:
=C2<>"West"It is FALSE for the two West orders and TRUE for the other four. Text in a formula goes in double quotes, and the comparison ignores case, so "west" gives the same result.
There is no != in Excel. If you are used to SQL or Python, that is the first habit to drop. The NOT function gives the same answer as <> on a single test (=NOT(C2="West")), and is mainly useful for reversing a longer condition such as NOT(OR(...)).
Logical operators in Excel: AND, OR and NOT
The comparison operators test one thing. To combine tests, Excel uses functions, not symbols:
=AND(E2>=500, C2="West")
=OR(E2>=500, C2="West")On our orders, the AND version is TRUE only for order 50112 (West and at least 500). The OR version is TRUE for orders 50112, 50287 and 50518: either the region is West or the amount is at least 500.
People searching for the "Excel logical OR" operator are usually looking for something like || or the word OR between two conditions. Excel has neither. =E2>=500 OR C2="West" is not a valid formula: the word OR has to come first, with the conditions in brackets.
OR and AND as arithmetic
Inside FILTER, SUMPRODUCT and other functions that work on whole ranges, the AND and OR functions do not work row by row, because they collapse the whole range into one TRUE or FALSE. The usual pattern is arithmetic: multiply conditions for AND, add them for OR.
=FILTER(A2:E7, (C2:C7="West") * (E2:E7>=500))
=FILTER(A2:E7, (C2:C7="West") + (E2:E7>=500))TRUE counts as 1 and FALSE as 0, so a product is 1 only when both tests pass, and a sum is at least 1 when either passes. The FILTER function guide walks through both on a larger table.
COUNTIF and SUMIF with greater than or equal to
COUNTIF, COUNTIFS, SUMIF and SUMIFS take the operator as part of a text criterion, so it goes inside quotes:
=COUNTIF(D2:D7, ">=500")That is the step most people get wrong when the threshold lives in a cell. The operator stays in quotes and the cell reference is joined on with &:
=COUNTIF(D2:D7, ">="&F2)Writing ">=F2" puts the letters F and 2 inside the text, so COUNTIF looks for amounts greater than or equal to the word "F2" and returns 0.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Order date | Amount | Threshold | Question | Result | |
| 2 | 50112 | West | 2025-06-12 | 500.00 | 500 | Amount >= 500 | 2 | |
| 3 | 50287 | West | 2025-06-30 | 499.50 | 2025-07-01 | Amount >= F2 | 2 | |
| 4 | 50341 | East | 2025-07-01 | 86.00 | Wrong: ">=F2" in quotes | 0 | ||
| 5 | 50518 | North | 2025-07-15 | 1,240.00 | Ordered on or after F3 | 4 | ||
| 6 | 50602 | South | 2025-08-04 | 100.00 | Between 100 and 500 | 4 | ||
| 7 | 50777 | East | 2025-09-19 | 312.00 | Region is not West | 4 | ||
| 8 | Total of amounts >= F2 | 1,740.00 |
The results:
- 2 orders of at least 500, whether the 500 is typed into the formula (H2) or read from F2 (H3).
- 0 from the formula with
">=F2"in quotes (H4). No error appears, which is what makes it dangerous. - 4 orders placed on or after 1 July 2025 (H5). Dates are numbers in Excel, so
">="&F3works exactly like an amount. - 4 orders between 100 and 500, both ends included (H6). Use COUNTIFS with two conditions on the same column for a range.
- 4 orders outside the West region (H7), using
"<>West". - 1,740.00 in total from the orders of 500 or more (H8).
For more on counting with several conditions, see COUNTIF with multiple criteria. For totals, see SUMIFS with multiple criteria.
Comparing dates, text and numbers stored as text
Comparison operators work on any type of value, but not always the way you expect:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Left | Right | Left >= Right | Left = Right | EXACT |
| 2 | West | west | TRUE | TRUE | FALSE |
| 3 | Apple | Banana | FALSE | FALSE | FALSE |
| 4 | 500 | 100 | TRUE | FALSE | FALSE |
| 5 | 400 | 500 | FALSE | FALSE | FALSE |
| 6 | 2025-07-01 | 2025-06-30 | TRUE | FALSE | FALSE |
Text compares alphabetically and ignores case. "West" and "west" are equal (C2 and D2 are TRUE), and "Apple" is not greater than or equal to "Banana" (C3 is FALSE). When case matters, use EXACT, which returns FALSE for "West" and "west" (E2).
Dates compare by their serial number. 1 July 2025 is greater than 30 June 2025, so C6 is TRUE. In a formula, build the date with DATE rather than typing it as text: =C2>=DATE(2025,7,1). Our date formulas guide explains why.
Text is always "greater" than a number. Row 4 holds the text "500", and Excel ranks any text above any number in a comparison, so "500">=100 is TRUE. Row 5 shows the other side: the number 400 compared with the text "500" is FALSE, and so would 4,000 be. Numbers stored as text often arrive from CSV exports and copied web tables. They are usually left-aligned in the cell, and they make a >= test silently wrong. Convert them with VALUE first, as shown in our guide to extracting text from a cell.
Excel wildcard characters
The comparison operators match whole values. To match part of a text value, functions that take a criterion (COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF and the IFS versions) and exact-match lookups (MATCH, VLOOKUP with FALSE, XLOOKUP with match mode 2) understand three wildcard characters:
| Wildcard | Matches | Example | Matches |
|---|---|---|---|
* | any number of characters, including none | "*Hotels" | Harbor & Pine Hotels, Willow Hotels |
? | exactly one character | "Oak ????" | Oak Labs, but not Oak Academy |
~ | makes the next *, ? or ~ literal | "*~**" | text with a real asterisk in it |
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Customer | Equals "*Hotels" | COUNTIF "*Hotels" | Question | Result | |
| 2 | Harbor & Pine Hotels | FALSE | 1 | Names ending in Hotels | 2 | |
| 3 | Willow Hotels | FALSE | 1 | Names containing bakery | 2 | |
| 4 | Oak Labs | FALSE | 0 | Names starting with O | 2 | |
| 5 | Orchard Bakery | FALSE | 0 | Position of the first Labs | 3 | |
| 6 | River Bakery | FALSE | 0 | |||
| 7 | Copper Labs | FALSE | 0 |
Column B is FALSE on every row. The = operator compares text exactly, so A2="*Hotels" only matches a cell that literally contains an asterisk followed by "Hotels". The wildcard only works inside COUNTIF in column C, which returns 1 for the two hotel customers.
The questions on the right return 2 customers ending in "Hotels", 2 containing "bakery" (in any case), 2 starting with O (Oak Labs and Orchard Bakery), and position 3 for the first name ending in "Labs".
The asterisk in an Excel formula
Outside quotes, * is multiplication: =C2*1.2. Inside a criterion string it is a wildcard: "*Hotels". A criterion that combines both is common when the search text is in a cell:
=COUNTIF(A2:A7, "*"&E2&"*")That counts names containing whatever is typed in E2. To count cells that contain an actual asterisk, put a tilde in front of it: "*~**". Wildcards do not work in = comparisons, IF tests, FIND or EXACT. SEARCH does accept them, which is one of the differences between FIND and SEARCH.
Common mistakes
Typing the symbol instead of the operator. ≥ and ≤ look right but are not operators. In a formula Excel rejects them, and inside a criterion string they match nothing.
Writing the operator backwards. => is not the same as >=. In a cell, =E2=>500 is rejected. In a criterion, "=>500" asks for cells equal to the text ">500", so COUNTIF returns 0. The equals sign always comes second: >= and <=.
Putting the cell reference inside the quotes. ">=F2" compares against the text "F2". Close the quotes before the reference and join it with &: ">="&F2.
Quoting a number in a direct comparison. =E2>="500" compares a number with text, so it is FALSE for every amount. Quotes around numbers belong only inside COUNTIF-style criteria, where the whole criterion is text.
Using > where the rule says "at least". This is a common slip in formulas written by an AI assistant: asked for "orders of 500 or more", it may write >500. The formula has no error and looks right on most rows. To catch it, test a row that sits exactly on the boundary. If an order of exactly 500 is labelled "Standard", the operator is wrong.
Chaining comparisons. =100<=E2<=500 does not test a range. Excel works it out left to right and compares TRUE or FALSE with 500. Use =AND(E2>=100, E2<=500), or COUNTIFS with two conditions when you are counting.
FAQ
How do you type greater than or equal to in Excel?
In a formula, type >=: the greater-than sign, then the equals sign, with no space. For the ≥ symbol as text, use Insert > Symbol, Alt+242 on a Windows numeric keypad, or =UNICHAR(8805).
What is the Excel formula for greater than or equal to?
=A2>=B2 returns TRUE or FALSE. To return a label, wrap it in IF: =IF(A2>=500, "Large", "Standard"). To count matching cells, use =COUNTIF(A2:A100, ">=500").
How do I write "not equal to" in Excel?
Use <>. For example =C2<>"West" returns TRUE for every region except West, and =COUNTIF(C2:C100, "<>West") counts those rows.
How do I use greater than or equal to a cell value in COUNTIF?
Keep the operator in quotes and join the cell with &: =COUNTIF(D2:D100, ">="&F2). Writing ">=F2" returns 0, because the reference is treated as text.
Does greater than or equal to work with dates?
Yes. Dates are stored as numbers, so =C2>=DATE(2025,7,1) is TRUE for 1 July 2025 and later. In COUNTIF, use ">="&DATE(2025,7,1) or a cell that holds the date.
What are the wildcard characters in Excel?
* matches any number of characters, ? matches exactly one, and ~ makes the next wildcard literal. They work in COUNTIF, SUMIF, their IFS versions, MATCH, exact-match VLOOKUP and XLOOKUP in match mode 2, but not with the = operator.
Practise this on a realistic dataset
Solve it yourself on one company's data, with instant feedback that points at what's wrong without giving away the answer.
Try “Hit or missed?” →