In Excel, “not greater than” means less than or equal to, and the operator is <=. For example, a formula such as =A1<=B1 returns TRUE when the value in A1 is less than or equal to the value in B1, and FALSE when it is greater.
What “not greater than” means in Excel
“Not greater than” is a comparison, not a special Excel function. It includes two possibilities: the first value is smaller, or it is exactly equal to the second value. That inclusive equality is what distinguishes “not greater than” from “less than.” In ordinary mathematical notation, the relationship is often written as ≤; in an Excel formula, type the two characters <=.
Excel uses comparison operators to test relationships between values. The main operators are:
=means equal to.>means greater than.<means less than.>=means greater than or equal to.<=means less than or equal to, or not greater than.<>means not equal to.
These operators are commonly used in formulas that return TRUE or FALSE, and inside functions such as IF, COUNTIF, and SUMIF. They can also define rules for conditional formatting. The meaning stays the same in each case, although a function may require the comparison to be entered as text rather than typed directly as an operator.
How to write the operator in a formula
Start a worksheet formula with an equals sign, then enter the first cell reference, the operator, and the second reference or value. Do not put a space between the less-than and equals signs. Excel recognizes <= as one comparison operator; reversing the characters or omitting the equals sign changes the meaning or causes a formula error.
With a number in A1, the formula =A1<=10 tests whether that number is 10 or less. If A1 contains 10, the result is TRUE; if it contains 12, the result is FALSE. The boundary matters: a value exactly equal to the limit passes a not-greater-than test.
With the values to compare in A2 and B2, enter =A2<=B2 in C2. If A2 contains 8 and B2 contains 8, C2 displays TRUE. If A2 contains 9 while B2 contains 8, it displays FALSE. You can fill the formula down to compare each row; relative references adjust automatically, so the next row will compare A3 with B3.
To compare every row against one fixed limit, make the limit reference absolute. With the value being checked in A2 and the threshold in B1, enter =A2<=$B$1 in C2 and copy it down. The dollar signs keep B1 fixed as the formula moves. This is useful for checking whether each order, score, or measurement is within a single shared cap.
Using not greater than with IF
A bare comparison gives a logical result, TRUE or FALSE. IF lets you display a label or choose between two calculations based on that result. This is a common way to turn a comparison into a readable status column. For example, an order total can be marked within a spending limit when it does not exceed a specified amount.
With an order total in B2 and a limit of 100, enter =IF(B2<=100,"Within limit","Over limit"). If B2 is 100, the formula returns Within limit; if B2 is 100.01, it returns Over limit. The first result is used when the comparison is TRUE, and the second when it is FALSE. You can replace the number 100 with a cell reference so the limit is easy to change.
With a student score in B2 and a passing threshold in D1, enter =IF(B2<=D1,"At or below threshold","Above threshold"). If B2 is 72 and D1 is 75, the result is At or below threshold. Notice that this describes whether a score is at or below the threshold; if the task is to identify a passing score of at least 75, the correct comparison is instead >=. Choose the operator to match the rule, rather than relying on a label that could accidentally reverse its meaning.
You can also express the same test as NOT of a greater-than comparison. With a numeric value in A2 and a limit of 10, =NOT(A2>10) returns TRUE for 10 or less. This is logically equivalent to =A2<=10 when the comparison produces TRUE or FALSE. The direct <= form is usually clearer because it states the intended boundary in one step.
Counting and adding values at or below a limit
COUNTIF counts cells that meet one condition. Its criteria argument is text, so a fixed limit can be written as a quoted condition. With numbers in B2:B10, enter =COUNTIF(B2:B10,"<=100") to count values that are 100 or less. If the qualifying values are 72, 100, and 45, the result is 3.
When the threshold is stored in a cell, join the comparison text to the cell reference. With numbers in B2:B10 and the threshold in E2, enter =COUNTIF(B2:B10,"<="&E2). If E2 contains 100, this counts values at or below 100. The ampersand joins the text operator to the cell’s value; entering the reference inside the quoted text would make Excel treat it as literal characters instead of a reference.
SUMIF uses a similar criteria argument but adds values associated with rows that meet the condition. With dates in A2:A6, sales amounts in B2:B6, and a cutoff date in D1, enter =SUMIF(A2:A6,"<="&D1,B2:B6). This adds the sales amounts for dates on or before D1. For example, if the matching rows contain 20, 35, and 10, the result is 65. Check that the criteria range and sum range cover corresponding rows.
Comparing dates, times, and text
Excel stores valid dates as serial numbers, so the same comparison works for dates. A date that is earlier than a cutoff is less than that cutoff, and a date on the cutoff is equal to it. With a due date in A2 and a deadline in B2, =A2<=B2 returns TRUE when the due date is on or before the deadline. Format the cells as dates so the values are easy to read, but remember that formatting changes their display, not the underlying comparison.
Times are stored as fractions of a day. A value of 12:00 PM represents half a day, for example. Comparing times with <= works when the cells contain valid Excel time values, but a date-and-time value includes both parts. If a cell contains a date plus a time later on the cutoff date, it may be greater than a cutoff stored as midnight on that date. To include the entire cutoff day, use a suitable next-day boundary or compare dates separately, depending on the worksheet’s purpose.
Excel can compare text too, but text comparisons are generally not a good way to test numeric limits. Sorting and comparison rules for text can produce results that surprise users expecting a numeric order. Numbers stored as text are another common source of confusion: a cell may look like 100 but be treated as text rather than a number. Convert such entries to real numbers before relying on numeric comparisons. Also, standard Excel text comparisons are not case-sensitive, so <= is not a substitute for a case-sensitive text test.
Highlighting values that do not exceed a limit
Conditional formatting can mark qualifying cells without adding a separate TRUE/FALSE column. Select the cells to format, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter a formula that returns TRUE for the first selected cell, choose a format, and confirm the rule.
For example, if the selected range begins at A2 and the shared limit is in B1, use =A2<=$B$1. The reference to A2 should be relative so Excel evaluates the matching row for each cell in the selected range; the limit remains fixed with dollar signs. If you select A2:A20, values at or below the limit will receive the chosen formatting. Make sure the formula’s starting reference matches the top-left cell of the selected range.
The built-in Highlight Cells Rules menu includes Less Than, but that rule excludes values equal to the entered threshold. Since “not greater than” includes equality, use a formula rule or another rule that explicitly includes equality when the boundary should count. This distinction can prevent an item exactly at a deadline, limit, or score threshold from being incorrectly left unmarked.
Common mistakes and how to fix them
- Leaving out the equals sign:
<means strictly less than, so a value equal to the threshold will not pass. Use<=when equality should count. - Reversing the operator:
>=means greater than or equal to, the opposite boundary direction. Check which value is on the left and which is on the right. - Putting quotes around a direct comparison: A formula like
="A1<=10"creates text rather than evaluating the comparison. Type the expression directly, without quotes. - Using a text criterion incorrectly: COUNTIF and SUMIF criteria need quotation marks around the operator text, and a cell-based threshold must be joined with
&. - Comparing numbers stored as text: Imported data may look numeric while remaining text. Check the cell format and convert the contents to numeric values if a comparison behaves unexpectedly.
- Using the wrong absolute references: When copying a formula, a changing threshold reference can shift to another cell. Lock a shared limit with dollar signs, such as
$B$1.
If the formula returns an error instead of TRUE or FALSE, inspect the referenced cells for existing errors such as #VALUE! or #N/A. A comparison involving an error can also return an error. Blanks and mixed data types can produce results that do not match a person’s informal expectation, so verify the actual cell contents rather than relying only on how they appear on screen.
Choosing the right comparison
Use <= when the rule means “at most,” “no more than,” “on or before,” or “within a maximum that includes the limit.” Use < when equality should fail, as in a rule that strictly requires a value below a threshold. Use >= for a minimum that includes the boundary, and > for a value that must exceed it.
A practical check is to test three cases: one value below the threshold, one exactly equal to it, and one above it. For a not-greater-than rule, the first two should pass and the last should fail. Testing the boundary is especially useful in workbooks that calculate eligibility, inventory limits, dates, or quality tolerances, because that is where an accidental switch between < and <= becomes visible.
Frequently Asked Questions
What is the Excel symbol for not greater than?
Use <=, which means less than or equal to. It includes values equal to the comparison value.
How do I write not greater than in an Excel formula?
Start with an equals sign and enter a comparison such as =A1<=B1. Excel returns TRUE if A1 is less than or equal to B1, otherwise FALSE.
Is not greater than the same as less than?
No. Not greater than includes equality, while less than does not. If the value is exactly the limit, <= is TRUE and < is FALSE.
Can I use not greater than in COUNTIF?
Yes. For a fixed limit, use a criterion such as =COUNTIF(A2:A20,"<=10"). For a limit in another cell, concatenate the operator text with that cell reference.
Why does a value equal to my limit fail a conditional formatting rule?
The built-in Less Than rule does not include equality. Use a formula-based rule with <= if the limit itself should qualify.
Related
- Data Cleaning in Excel: A Practical Example
- Data Cleaning Shortcuts in Excel: A Practical Guide
- Excel to PowerPoint Link: How to Keep Slides Updated
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Cell Value From List: Find or Select a MatchTo return a value from a list when you know a matching item, use XLOOKUP; with product IDs…
- Excel Date Subtraction: Formulas, Days, and WorkdaysTo subtract one date from another in Excel, subtract the earlier date cell from the later one: if…
- Excel Count Nonblank Cells: Formulas and ExamplesTo count nonblank cells in Excel, use =COUNTA(A2:A20), replacing the range with the cells you want to check.…
- Insert a Horizontal Page Break in Excel the Right WayTo insert a horizontal page break in Excel for Microsoft 365 on Windows, select the row directly below…
- Excel Data Sorting: Sort Rows, Columns, and Lists CorrectlyTo sort data in Excel for Microsoft 365 on Windows, click a cell in the column you want…
- SUMPRODUCT Excel: Calculate a Weighted AverageIn Excel, calculate a weighted average with =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5), assuming A2:A5 contains the values and B2:B5 contains their weights.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.