Excel Greater Than or Equal To: Formula and Examples

Formulas & functions · Updated November 18, 2026

In Excel, the greater-than-or-equal-to operator is >=. Put it between two values in a formula, such as =A1>=B1, and Excel returns TRUE when the value on the left is greater than or equal to the value on the right, or FALSE when it is not.

The same operator works in logical tests, functions such as IF, and criteria used by functions such as COUNTIF and SUMIF. Knowing where to put it—and how Excel treats the values being compared—helps avoid common errors around thresholds, dates, text, and conditional formatting.

What the >= operator means

The operator combines two comparisons: greater than (>) and equal to (=). As a result, equality counts as a match. If a score is exactly 70, then comparing it with a threshold of 70 using >= returns TRUE. A comparison using only > would return FALSE in that case.

With a test value in A1 and a threshold in B1, enter =A1>=B1 in another cell. If A1 contains 84 and B1 contains 80, the result is TRUE. If A1 contains 76 and B1 contains 80, the result is FALSE. The comparison itself does not display a custom message; it produces a logical value that other formulas can use.

Excel formulas begin with an equals sign, while the comparison operator goes between the two values or references. The order matters: A1>=B1 asks whether A1 is at least B1. Reversing the references asks a different question. The operator is typed as the greater-than sign followed by the equals sign; => is not the correct Excel operator.

Use the comparison by itself

A direct comparison is useful when you want a visible TRUE or FALSE result, or when you need a basic test to build into a larger calculation. For example, a quantity can be compared with a reorder point, a payment date with a deadline, or a measured value with a minimum requirement. The result updates when the referenced cells change.

With the current quantity in A2 and the reorder point in B2, enter =A2>=B2 in C2. If A2 is 12 and B2 is 10, C2 displays TRUE, because 12 is greater than 10. If A2 is 10, it also displays TRUE because the values are equal. If A2 is 9, the result is FALSE.

TRUE and FALSE are logical values, not just words typed into a cell. Excel can use them in later tests and calculations. You can also format the result cell as ordinary text display, but changing its appearance does not change the comparison result.

Return a message with IF

Most worksheets need a useful label rather than a bare TRUE or FALSE. IF checks a condition and returns one result when it is TRUE and another when it is FALSE. The comparison goes in IF’s first argument, followed by the value to return for a match and the value to return otherwise.

With a score in B2 and a pass threshold in E1, enter =IF(B2>=E1,"Pass","Review") in C2. If B2 is 80 and E1 is 80, the result is Pass; if B2 is 79, the result is Review. The quotes around the text results are required, and the comma separators are the standard syntax in Excel configured to use commas. Some regional settings use semicolons as formula separators; in that case, Excel may adjust the formula syntax for that environment.

Keeping the threshold in a separate cell makes the worksheet easier to maintain. If the requirement changes, update E1 rather than editing the formula in every row. When copying the formula down, use an absolute reference for a threshold that must stay fixed. With scores in B2:B20 and the fixed threshold in E1, enter =IF(B2>=$E$1,"Pass","Review") in C2 and fill down. The row reference for the score changes, while $E$1 remains fixed.

Combine the test with other conditions

A value meeting a minimum may not be enough on its own. AND can require multiple conditions to be TRUE, while OR can accept a match when at least one condition is TRUE. These functions are especially useful for eligibility checks, quality rules, and status labels.

With a score in B2, attendance percentage in C2, and the required minimums in E1 and F1, enter =IF(AND(B2>=$E$1,C2>=$F$1),"Eligible","Not eligible") in D2. If the minimum score is 70 and the minimum attendance is 0.9, a score of 75 with attendance of 90% returns Eligible. A score of 75 with attendance of 89% returns Not eligible. Excel stores 90% as 0.9, so the threshold must use a compatible scale.

Use AND when every requirement must be met. If a person qualifies by meeting either a score threshold or an attendance threshold, OR may be appropriate instead. Decide what the rule means before writing the formula: changing AND to OR can significantly change which rows qualify.

Use >= in COUNTIF and SUMIF

COUNTIF and SUMIF let you apply a threshold across a range. Their criteria argument is text that describes the comparison, so the operator and threshold appear inside quotation marks. This differs from a direct logical comparison, where the operator sits between cell references.

With scores in B2:B6 and corresponding study hours in C2:C6, enter =COUNTIF(B2:B6,">=80") to count scores of at least 80. If the scores are 92, 80, 77, 100, and 65, the result is 3. The score equal to 80 is included.

With the same score and study-hour layout, enter =SUMIF(B2:B6,">=80",C2:C6) to add the study hours for rows whose score is at least 80. If the corresponding hours are 4, 3, 5, 2, and 6, the result is 9: the qualifying rows contribute 4, 3, and 2 hours. The criteria range and sum range should align row by row.

If the threshold is stored in E1, join the operator with the cell reference using an ampersand. With scores in B2:B20 and the threshold in E1, enter =COUNTIF(B2:B20,">="&E1). This lets you change the threshold without rewriting the criteria. When a criteria string is built this way, the comparison operator still needs to be included as text.

Compare dates and times

Excel stores dates as serial numbers and times as fractions of a day, so the comparison operator can test them just as it tests other numeric values. A deadline check, for example, can determine whether an entered date is on or after a required date. Make sure both cells contain actual Excel date values rather than text that merely looks like a date.

With a submitted date in A2 and a deadline in B2, enter =A2>=B2 in C2. If A2 contains 15 March 2026 and B2 contains 15 March 2026, the result is TRUE because the dates are equal. If A2 is 14 March, the result is FALSE. The display format can show dates in different regional styles without changing their underlying values.

Time comparisons work similarly, but watch out for dates that include a time component. A cell displaying only a date may also contain a time, and that hidden portion can affect a comparison. If two values appear to be the same date but the result is unexpected, inspect their number formats and underlying values. Avoid converting dates to text merely to make them look consistent; text is not always comparable in the same way as real date values.

Highlight values that meet a threshold

Conditional formatting can emphasize qualifying cells without adding a helper formula column. To highlight values greater than or equal to a threshold, select the cells and choose Home > Conditional Formatting > New Rule. Choose “Use a formula to determine which cells to format,” enter a formula, choose a format, and select OK.

With values in B2:B100 and the top cell of the selected range being B2, enter =B2>=$E$1 as the rule formula to compare each value with the fixed threshold in E1. The relative B2 reference adjusts for each row, while the absolute E1 reference stays fixed. The formula should be written for the first cell in the selected range; if the selected range starts in B5, use B5 in the formula instead.

Excel also offers Home > Conditional Formatting > Highlight Cells Rules > Greater Than, but that preset checks strictly greater than, not greater than or equal to. For an inclusive threshold, a formula-based rule is the more precise choice. Conditional formatting changes how cells look, not the values they contain, so formulas that use those cells still evaluate the underlying data.

Common mistakes and troubleshooting

If a comparison gives an unexpected result, check the values and references before changing the operator. A formula can be syntactically correct and still test the wrong cells, compare unlike data types, or use a threshold that is stored as text.

  • Using the wrong order: A2>=B2 and B2>=A2 are different tests. Confirm which value is being tested and which is the limit.
  • Leaving out equality: > excludes a value exactly equal to the threshold. Use >= when equality should qualify.
  • Comparing text to numbers: A number stored as text may not behave as intended in a numeric test. Convert the data to consistent numeric values and check for leading apostrophes or imported text.
  • Mixing units or scales: Comparing 90% with 90, or dollars with cents, can produce a valid but misleading result. Standardize the values and threshold first.
  • Using a moving threshold reference: If a formula is copied down, an unanchored threshold reference may shift. Use dollar signs, such as $E$1, when the threshold must remain in one cell.
  • Typing a criteria incorrectly: COUNTIF and SUMIF criteria need a text criterion such as ">=80", or a joined operator and cell reference. A bare comparison in that argument is not equivalent.

For a quick check, select the formula cell and inspect the formula bar, then click each referenced cell to confirm its contents. You can temporarily format suspected numeric cells as General or use a separate test cell to see whether Excel treats the input as expected. Correcting the source data is often better than building workarounds into every comparison formula.

Frequently Asked Questions

What is the Excel symbol for greater than or equal to?
Use >=, with the greater-than sign first and the equals sign second. Excel does not use => for this comparison.

How do I write greater than or equal to in an IF formula?
Put the comparison in IF’s logical test. With a value in A2 and a threshold in B2, use =IF(A2>=B2,"Yes","No"). This returns Yes when A2 is equal to or above B2.

Does greater than or equal to include the exact threshold?
Yes. If the two values being compared are equal, the test returns TRUE. Use only > if the value must be strictly higher.

How do I count cells greater than or equal to a value?
With numbers in A2:A20 and a threshold of 50, use =COUNTIF(A2:A20,">=50"). To use a threshold stored in B1 instead, join the criterion text to the reference with an ampersand.

Why does my greater-than-or-equal formula return FALSE?
Check that the referenced cells contain the values you expect, that the threshold is correct, and that numbers or dates are not stored as text. Also confirm that you used the right cell order and included equality in the operator.

Choosing the right approach

Use a direct comparison when TRUE or FALSE is useful on its own. Use IF when you need a label or a different result for each outcome, and combine the test with AND or OR when your rule has multiple requirements. Choose COUNTIF or SUMIF when you want to count or total a range based on a threshold, and conditional formatting when the goal is visual emphasis rather than a new calculated result.

The key decision is what “at least” means in the worksheet: identify the value, identify the threshold, and decide whether equality should count. Once those are clear, >= provides a simple, reusable test across ordinary formulas, dates, summary calculations, and formatting rules.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.