To use greater than or equal to in Excel, select an empty cell, type =A2>=B2, and press Enter. Excel returns TRUE when A2 is greater than or equal to B2 and FALSE otherwise. Type the greater than sign immediately followed by the equals sign to form >=.
For a result such as Pass or Fail, use =IF(A2>=100,"Pass","Fail") in Excel for Microsoft 365 or Excel 2024 on Windows and Mac, or Excel for the web. The basic comparison also works in current Excel mobile apps. Check the platform details below before following steps for other functions or menus.
The short version
- Compare values: Use
=A2>=B2to test whether A2 meets or exceeds B2. - Choose your result: Use
IFto return labels instead of TRUE and FALSE. - Count or total matches: Put criteria such as
">=100"inside quotation marks inCOUNTIFandSUMIF. - Keep symbols separate: The display character ≥ is text, while
>=performs the comparison in formulas.
| Your task | Method | Result |
|---|---|---|
| Compare two values | Direct comparison with >= | TRUE or FALSE |
| Show a custom label | IF | Text such as Pass or Fail |
| Count with one condition | COUNTIF | Number of qualifying cells |
| Count with multiple conditions | COUNTIFS | Number meeting all conditions |
| Total with one condition | SUMIF | Sum of qualifying values |
| Total with multiple conditions | SUMIFS | Sum meeting all conditions |
| Highlight cells or rows | Conditional formatting formula | Chosen appearance for matches |
| Show qualifying source rows | AutoFilter | Filtered worksheet data |
| Return matching rows elsewhere | FILTER | Results in neighboring cells |
| Generate the ≥ character | UNICHAR | A symbol or text label |
| Insert ≥ on macOS | Character Viewer | A character in cell text |
Compare two cells or a fixed number
Select an empty result cell and enter the following formula. Press Enter to compare the value in A2 with the value in B2.
=A2>=B2Equality counts as a match, so two cells containing 100 return TRUE. A2 containing 120 and B2 containing 100 also returns TRUE. When A2 contains 90 and B2 contains 100, the result is FALSE.
Replace the second cell reference with a number when you want a fixed cutoff. Enter the following formula to test whether A2 is at least 100, then press Enter.
=A2>=100Keep the characters in the order >=, with no space between them. Neither => nor the single character ≥ substitutes for this comparison operator.
Show Pass or Fail with IF
Use IF when a descriptive result is more useful than TRUE or FALSE. In Excel for Microsoft 365 and Excel 2024 on Windows and Mac, or Excel for the web, select the result cell and enter this formula, then press Enter.
=IF(A2>=100,"Pass","Fail")A value of 100 or more returns Pass, while a value below 100 returns Fail. The comparison goes first, followed by the result for a true comparison and the result for a false comparison. Keep quotation marks around the text labels, but leave the comparison itself outside quotation marks.
A target stored in another cell works the same way. Enter the following formula to compare A2 with B2, then press Enter.
=IF(A2>=B2,"Met target","Below target")You can replace the two labels with text that suits your sheet. When you use IF statements in Excel, keep the same structure of a condition followed by its two possible results.
Count cells that meet your threshold
In Excel for Microsoft 365 and Excel 2024 on Windows and Mac, COUNTIF counts cells that meet one condition. Select a result cell, enter this formula, and press Enter to count values of at least 100 in A2 through A100.
=COUNTIF(A2:A100,">=100")Unlike a direct comparison, this function takes the operator and fixed threshold together as quoted criteria. When your threshold is stored in E1, keep the operator in quotation marks and join it to the cell reference with an ampersand. Enter this formula and press Enter.
=COUNTIF(A2:A100,">="&E1)For multiple conditions, use COUNTIFS, which also works in Excel for the web. The following formula counts rows where column A is at least 100 and column B contains Paid. Enter it in the result cell and press Enter.
=COUNTIFS(A2:A100,">=100",B2:B100,"Paid")Each criteria range must have matching dimensions, as A2:A100 and B2:B100 do here. To count an inclusive range instead, use =COUNTIFS(A2:A100,">=100",A2:A100,"<=200"), which includes both 100 and 200.
Add values that meet a minimum
Use SUMIF in Excel for Microsoft 365 or Excel 2024 on Windows and Mac to add qualifying numbers. Enter the following formula in an empty cell and press Enter to total values in A2:A100 that are at least 100.
=SUMIF(A2:A100,">=100")The values you add can also come from a different column. Enter this formula and press Enter to check column A against the threshold in E1, then add the corresponding values from column B.
=SUMIF(A2:A100,">="&E1,B2:B100)When more than one condition must be met, use SUMIFS, which also works in Excel for the web. Enter this formula and press Enter to total column C only when column A meets the E1 threshold and column B contains Paid.
=SUMIFS(C2:C100,A2:A100,">="&E1,B2:B100,"Paid")Pay attention to the argument order when switching functions. SUMIFS puts the sum range first, while the separate sum range in SUMIF comes after its criterion.
Highlight cells or entire rows
On Windows in Excel for Microsoft 365 or Excel 2024, select A2:A100. Choose Home > Conditional Formatting > New Rule, then select Use a formula to determine which cells to format. Enter this formula in the rule.
=A2>=100Select Format, choose the appearance you want, and select OK to close the formatting dialogs. The rule applies that appearance to cells meeting the threshold. These steps use the Windows rule dialog; Mac and web interfaces can differ.
To highlight entire rows based on column B, select A2:D100 before creating the rule. Use the following formula so each row's formatting depends on its value in column B, then choose the appearance through Format and select OK to close the dialogs.
=$B2>=100Show only rows that qualify
AutoFilter lets you filter the source data by a minimum value. In Excel for Microsoft 365 on Windows or Mac, or Excel 2024 on Windows, select a cell in your data and choose Data > Filter. Open the numeric column's header arrow.
On Windows, choose Number Filters > Greater Than or Equal To, enter your threshold, and select OK. On Mac with Microsoft 365, use Choose One to select Greater Than or Equal To, then enter the threshold. The default Auto Apply setting updates the filtered results.
For matching rows in another area, use FILTER in Excel for Microsoft 365 or Excel 2024 on Windows and Mac, Excel for the web, or current Excel mobile apps. Select an empty cell with space below and to its right, enter the following formula, and press Enter.
=FILTER(A2:C100,B2:B100>=E1,"No matches")This returns rows from A2:C100 where the value in column B meets or exceeds E1. Results spill into neighboring cells and update when source values change. The formula displays No matches when no rows qualify.
Insert the greater than or equal to symbol
Use the ≥ character when you want a label rather than a calculation. In Excel for Microsoft 365 or Excel 2024 on Windows and Mac, enter this formula and press Enter to display the symbol.
=UNICHAR(8805)For a label containing both the symbol and a number, enter =UNICHAR(8805)&" 100". The result is the text ≥ 100. It does not compare another cell with 100.
On current macOS with Excel for Microsoft 365, Excel 2024, or Excel for the web, place the insertion point in cell text and choose Edit > Emoji & Symbols. Search for greater than or equal to and select ≥. In the expanded Character Viewer, double-click the symbol.
Correct the formula syntax
Start with the operator when your formula does not give the intended comparison. A direct test uses =A2>=100, with the initial equals sign starting the formula and >= between the values. Replace a pasted ≥ character or reversed => with >=.
Next, check quotation marks against the function you chose. In IF, write the comparison as A2>=100; in COUNTIF or SUMIF, write a fixed criterion as ">=100". For a threshold in E1, use ">="&E1 so the cell reference stays outside the quotation marks.
Finally, check the ranges and argument order in formulas with multiple conditions. COUNTIFS needs criteria ranges with matching dimensions, and SUMIFS needs the sum range first. Those details matter even when the comparison operator itself is correct.
Frequently Asked Questions
How do you test whether two cells both meet a minimum?
In Excel for Microsoft 365 and Excel 2024 on Windows and Mac, or Excel for the web, use =AND(A2>=100,B2>=100). This returns TRUE only when both cells meet the minimum. Use =OR(A2>=100,B2>=100) when either cell meeting the minimum is enough.
How do you assign different results for several thresholds?
In Excel for Microsoft 365 and Excel 2024 on Windows and Mac, use =IFS(A2>=90,"A",A2>=80,"B",A2>=70,"C",TRUE,"Below C"). Put the highest threshold first because IFS returns the result associated with the first TRUE condition. The final TRUE supplies the result when none of the earlier thresholds is met.
Can you require entered numbers to be at least 100?
Yes, in Excel for Microsoft 365 and Excel 2024 on Windows and Mac, and Excel for the web, select the input cells and open Data > Data Validation > Settings. Under Allow, choose Whole Number or Decimal, then under Data choose greater than or equal to. Enter 100 in Minimum and select OK. The rule blocks invalid values typed directly into those cells, but data that is copied or filled into them can bypass it.
Why might an English formula need different separators?
Regional Excel installations can require different separators or localized function names. The examples here use English function names and commas, so adapt those parts to your installation's formula syntax.