Excel IF Greater Than: Formulas, Examples, and Rules

Formulas & functions · Updated November 20, 2026

In Excel, use the greater-than operator > to test whether one number exceeds another; wrap the test in IF when you want a particular result. If A2 contains 125, for example, =IF(A2>100,"Greater than 100","Not greater than 100") returns Greater than 100.

How the greater-than test works

The symbol > compares the value on its left with the value on its right. The test is TRUE only when the left value is strictly larger. If the values are equal, or the left value is smaller, the test is FALSE. The operator works by itself in a formula, or as the logical test inside functions such as IF, COUNTIF, and SUMIF.

For a direct comparison, with A2 containing 125 and B2 containing 100, =A2>B2 returns TRUE. If A2 contains 100 instead, the result is FALSE because equality does not count as greater than. Excel displays these logical results as TRUE and FALSE, and other formulas can use them in further calculations.

In an IF formula, the general pattern is =IF(logical_test,value_if_true,value_if_false). The logical test can be a comparison such as A2>100. Excel checks it, then returns the second argument if it is TRUE or the third argument if it is FALSE. The returned values can be text, numbers, cell references, or other formulas.

Basic IF formula examples

Assume A2 contains a score of 82. To label scores above 70, enter =IF(A2>70,"Pass","Review"); the result is Pass. This checks whether the score is strictly above 70, so a score of exactly 70 produces Review. The quoted words are text values, while A2 and 70 are the values being compared.

If you want a numeric result instead, and A2 contains 125, use =IF(A2>100,10,0). Excel returns 10 because the test is true; if A2 were 100 or less, it would return 0. Numeric outcomes can be useful in later totals, charts, or calculations, while descriptive text is usually easier for people to scan.

To show the comparison result without an IF, use =A2>100. With 125 in A2, the result is TRUE; with 90, it is FALSE. This shorter approach is handy when you need a logical value for another formula or want to inspect whether the comparison itself is working.

Enter a formula in a cell by typing an equals sign, the formula, and then pressing Enter. To apply the same comparison down a column, use a relative reference such as A2 in the formula and fill or copy it downward. Excel will adjust the reference to A3, A4, and so on. If the threshold is in a cell that should stay fixed while copying, an absolute reference such as $B$1 keeps that reference anchored.

Choosing between greater than and greater than or equal to

A frequent source of mistakes is treating greater than as if it includes equality. It does not: > means strictly greater. Use >= when the boundary value should also qualify. For example, if the rule is that a payment of at least 100 meets a target, the relevant comparison is 100 or more, not more than 100.

With the target in B1 and a value in A2, the formula =IF(A2>=B1,"Target met","Below target") returns Target met when A2 equals or exceeds B1. If B1 is 100 and A2 is exactly 100, it returns Target met. Replacing >= with > would return Below target for that same boundary value.

The related operators are < for less than, <= for less than or equal to, and = for equal to. Excel also uses <> for not equal to. These operators can be used in IF tests and in criteria for functions such as COUNTIF. Pick the one that matches the rule precisely, especially for grades, deadlines, quotas, and eligibility thresholds.

Comparing against a cell or combining conditions

Using a cell for the threshold makes a worksheet easier to update. For instance, with actual values in A2:A20 and a target stored in B1, an IF formula in C2 can compare A2 with B1. If B1 changes, the comparison updates without editing every formula. To fill the formula down while keeping the target fixed, use =IF(A2>$B$1,"Above target","At or below"). With A2 equal to 125 and B1 equal to 100, it returns Above target.

Sometimes a value must meet more than one condition. Suppose A2 contains a score and B2 contains an attendance percentage; a person qualifies only if the score is greater than 70 and attendance is at least 80%. With A2 equal to 82 and B2 equal to 0.9, =IF(AND(A2>70,B2>=80%),"Qualifies","Does not qualify") returns Qualifies. AND requires every listed condition to be TRUE.

Use OR when any one of several conditions is enough. For example, if a value in A2 qualifies by being below 10 or above 100, and A2 is 125, =IF(OR(A2<10,A2>100),"Outside range","Within range") returns Outside range. AND and OR can be combined for more complex rules, but breaking a long test into helper columns often makes a workbook easier to check and maintain.

Counting and highlighting values above a threshold

If you need a count rather than a label for every row, COUNTIF accepts a greater-than criterion. With numbers in A2:A10, =COUNTIF(A2:A10,">100") counts cells whose values are above 100. If the range contains 105, 120, and 100 among otherwise smaller numbers, the result is 2: the two values above 100 count, but 100 itself does not.

When the threshold is in a cell instead of typed into the criterion, join the operator to the cell reference. With values in A2:A10 and the threshold in B1, =COUNTIF(A2:A10,">"&B1) counts entries above the value in B1. If B1 contains 100 and the range has 105, 120, and 100 as its only values above or at the threshold, the result is 2. The ampersand joins the greater-than symbol with the threshold so COUNTIF receives a criterion such as >100.

To add the values above a threshold rather than count them, use SUMIF. With values in A2:A10 and 100 as the cutoff, =SUMIF(A2:A10,">100",A2:A10) adds only values greater than 100. If the qualifying values are 105 and 120, the result is 225. SUMIF can also use a separate sum range when the values to test and the values to add are in different columns.

For a visual highlight without adding a formula column, select the cells, then choose Home > Conditional Formatting > Highlight Cells Rules > Greater Than. Enter the cutoff and choose a format. This rule changes how qualifying cells look; it does not replace their values or create a TRUE/FALSE result. On Mac, the Conditional Formatting options are also on the Home tab, although the arrangement can differ slightly by Excel version. Excel for the web also provides conditional formatting, but its menus may differ from the Windows desktop steps.

Common problems and how to fix them

  • The boundary value fails unexpectedly: Check whether the rule needs >= instead of >. A value equal to the cutoff is not greater than it.
  • A number looks numeric but compares incorrectly: Data imported from a text file or copied from a website may be stored as text. Convert it to a number, for example with Excel’s Convert to Number option when it appears, or use Data > Text to Columns where appropriate. Check that the conversion did not alter important leading zeros in codes or identifiers.
  • The formula changes when copied: Relative references move as a formula is filled down. Use dollar signs to fix a threshold reference, such as $B$1, while allowing the row reference for the tested value to change.
  • A blank or missing value is treated as meaningful: Decide how blanks should be handled rather than assuming they are valid measurements. If only numeric entries should be compared, with a value in A2, =IF(AND(ISNUMBER(A2),A2>100),"Over 100","Check input") returns Over 100 when A2 contains 125 and Check input when A2 is blank or text.
  • The formula shows an error or will not enter: Check that parentheses and quotation marks are paired, that text results are enclosed in straight quotation marks, and that the formula begins with an equals sign. Excel’s argument separator may be a semicolon rather than a comma in some regional settings; use the separator expected by your installation.

Formatting can also make comparisons confusing. A cell formatted as currency or as a percentage still stores a numeric value, but the displayed value may be rounded. A cell showing 100.00 could contain 99.999, for example, and fail a test for greater than or equal to 100. Increase displayed decimal places or inspect the underlying value before changing the comparison rule.

Dates, percentages, and other numeric values

Excel stores dates as serial numbers, so greater-than comparisons can test which date comes later. With dates in A2 and a deadline in B1, =A2>B1 returns TRUE if the date in A2 is later than the date in B1. Make sure both cells contain actual Excel dates, not text that merely looks like a date. Date display formats do not change the underlying comparison.

Percentages are numeric too: 80% is stored as 0.8. If B2 contains 90%, compare it to 80% or 0.8, rather than to 80, which represents 8,000% when formatted as a percentage. The formula =B2>80% returns TRUE for B2 equal to 90%. This is why matching the units and scale of the values being compared matters as much as choosing the correct operator.

For decimals, Excel compares the stored values, not only the rounded figures visible on screen. If two prices display as 10.00 but have different underlying decimal amounts, a greater-than test may return TRUE. If a business rule requires rounding first, decide the required precision and round the values intentionally; do not rely on cell formatting to change the comparison.

Frequently Asked Questions

What is the Excel formula for greater than?
Use the > operator, as in =A2>B2. It returns TRUE when A2 is larger than B2 and FALSE when it is equal to or smaller than B2.

How do I write an IF formula for greater than 0?
If A2 contains the value, use =IF(A2>0,"Positive","Not positive"). A value of exactly zero returns Not positive because the test is strictly greater than zero.

Does greater than include the same number?
No. > excludes equality. Use >= when a value equal to the cutoff should pass the test.

How do I count numbers greater than a value in Excel?
With the numbers in A2:A10 and a fixed cutoff of 100, use =COUNTIF(A2:A10,">100"). To use a cutoff stored in B1, join the operator to the reference with an ampersand: =COUNTIF(A2:A10,">"&B1).

Can Excel highlight cells greater than a number?
Yes. Select the range and choose Home > Conditional Formatting > Highlight Cells Rules > Greater Than, then enter the cutoff and a format. This highlights qualifying cells without changing their contents.

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.