Excel has six comparison operators, and <= is one of the handiest. It asks a simple question: is this value smaller than or the same as that one?
The “or equal to” part is what makes it worth reaching for. A delivery that took exactly five days against a five day promise still counts as on time, and <= is what tells Excel to include it.
In this tutorial, I’ll walk you through seven ways to put <= to work, from a plain TRUE/FALSE comparison to conditional formatting and data validation rules.
Example #1: Use the Less Than or Equal to Operator to Compare Two Values
The simplest use of <= is a straight comparison between two cells. Excel hands back TRUE or FALSE, nothing else.
Below I have an order log with the number of days each delivery was promised in, and the number it actually took. I want to know which orders came in at or under the promise.
Here is the formula I’ll put in cell G2:
=E2:E11<=D2:D11
How does this formula work?
Excel compares each Actual Days value against the Promised Days value on the same row. If the actual is smaller or identical, you get TRUE.
Look at ORD-2043. It was promised in seven days and took exactly seven, and it still returns TRUE. That’s the “or equal to” half of the operator doing its job.
Because I handed the formula whole ranges, the results spill down the column on their own. In Excel 2019 or earlier, use =E2<=D2 in G2 and copy it down.
Example #2: Use the Less Than or Equal to Operator With the IF Function
TRUE and FALSE are accurate but not very readable. Wrap the same comparison in IF and you can return whatever wording you like.
Same order log as before. This time I want the column to say “On Time” or “Late” instead.
Here is the formula:
=IF(E2:E11<=D2:D11,"On Time","Late")
How does this formula work?
The test E2:E11<=D2:D11 is exactly what Example #1 did, so it produces the same TRUE/FALSE list behind the scenes.
IF then swaps each result for text. Every TRUE becomes “On Time” and every FALSE becomes “Late.”
This is the pattern most people are after when they ask how to do less than or equal to in Excel. It reads well, and you can feed the output straight into a filter or a pivot table.
Note: Enter a spilling formula like this outside an Excel Table. Spilled arrays aren’t supported inside Tables and can return #SPILL!.
Example #3: Use the Less Than or Equal to Operator With the COUNTIF Function
COUNTIF can count with a <= condition, but the syntax catches people out. The operator has to go inside quotes, and the value gets joined on with &.
Here I want to count how many orders came in at or below a value limit sitting in cell I1.
Here is the formula:
=COUNTIF(F2:F11,"<="&I1)
How does this formula work?
"<="&I1 builds the criteria as a piece of text. With 1250 in I1, Excel ends up reading the condition as "<=1250".
Six of the ten orders are at or below that, including the one sitting exactly on 1250.
Keeping the limit in a cell means you can change it and watch the count update, instead of editing the formula every time.
Note: Don’t write “<=I1” with the cell reference inside the quotes. Excel then looks for cells containing the literal text “I1” and returns 0. The ampersand has to sit outside the quotes.
If you need a strict cut off that excludes the boundary value, swap <= for <. I cover that in detail in how to count cells less than a value in Excel.
Example #4: Use the Less Than or Equal to Operator With the SUMIF Function
SUMIF uses the same criteria style as COUNTIF, but adds up a second column instead of counting rows.
I want the total value of every order that was delivered in five days or fewer.
Here is the formula:
=SUMIF(E2:E11,"<="&I1,F2:F11)
How does this formula work?
SUMIF checks the Actual Days column against "<=5", then totals the matching rows from the Order Value column.
Five orders clear the test, and their values add up to 7200. The order that took exactly five days is included, which is the whole point of using <= rather than <.
Note the argument order. The range you test comes first, and the range you actually add comes last.
Example #5: Use the Less Than or Equal to Operator With Dates
Dates are where <= trips people up most often. Excel stores dates as numbers, so the comparison works fine, but you can’t type the date straight into the criteria.
Here I want to count every order placed on or before a cutoff date.
Here is the formula:
=COUNTIFS(C2:C11,"<="&I1)
How does this formula work?
With the cutoff date in I1, "<="&I1 resolves to the date’s underlying serial number. Excel compares the Order Date column against that number and counts the matches.
Five orders were placed on or before 30 June 2026, so the answer is 5.
If you’d rather hard code the date, use the DATE function: =COUNTIFS(C2:C11,"<="&DATE(2026,6,30)).
Note: Never write the date as plain text, as in “<=30/06/2026”. Excel reads that as a text string rather than a date and quietly returns 0. Always point at a cell or wrap it in DATE.
Example #6: Use the Less Than or Equal to Operator With Conditional Formatting
<= isn’t only for formulas that return a value. It also works inside a conditional formatting rule, so rows highlight themselves.
I want to shade every order that was delivered in three days or fewer.
Here are the steps to highlight rows using a <= rule:
- Select the data range A2:F11.
- On the Home tab, click Conditional Formatting, then New Rule.
- Choose “Use a formula to determine which cells to format,” enter
=$E2<=3, pick a fill colour under Format, then click OK.
Three rows light up, the ones that took three days, three days and two days.
The dollar sign in $E2 locks the column but leaves the row free. That’s what lets one rule colour the whole row instead of a single cell.
Example #7: Use the Less Than or Equal to Operator With Data Validation
You can also use <= to stop bad data getting in. Data validation can reject any entry above a limit before it ever lands in the sheet.
I want to make sure nobody types a delivery time longer than 30 days into the Actual Days column.
Here are the steps to add a less than or equal to rule:
- Select the Actual Days range E2:E11.
- On the Data tab, click Data Validation.
- Set Allow to “Whole number”, set Data to “less than or equal to”, enter 30 as the Maximum, then click OK.
Now typing 45 into that column gets rejected, while 30 sails through.
Notice that Excel words the option as “less than or equal to” in plain English here. Behind the scenes it’s the same <= test.
Additional Notes About the Less Than or Equal to Operator in Excel
<=is two separate characters, typed in that order. The single ≤ glyph is display text and Excel’s formula parser rejects it. If you want that character for a label, see how to type the less than or equal to sign in Excel.- The operator works on text too, comparing alphabetically.
="apple"<="banana"returns TRUE. Excel’s default text comparison ignores case, so="APPLE"<="apple"also returns TRUE. - Blank cells count as zero in a
<=comparison, so=A1<=0returns TRUE when A1 is empty. Add a length check if that matters. - To test a range with both ends, pair
<=with>=. I walk through that in how to count between two numbers in Excel.
Frequently Asked Questions
Why does my COUNTIF with a <= condition return 0?
Almost always because the cell reference ended up inside the quotes. "<=I1" tells Excel to look for the literal text I1. Write "<="&I1 instead, with the ampersand outside the quotes.
Does the less than or equal to operator work with dates and text, or only numbers?
All three. Dates are compared as serial numbers and text is compared alphabetically. The only catch is dates in criteria strings, which need a cell reference or the DATE function rather than a typed date.
What’s the difference between <= and the ≤ symbol?
<= is an instruction that makes Excel compare two values and return TRUE or FALSE. ≤ is just a character for display, and Excel never treats it as an instruction.
Conclusion
<= earns its keep any time a boundary value should count. Delivered on the promised day, spent exactly to budget, finished right on the deadline: all of those pass with <= and fail with <.
Start with the IF pattern in Example #2, since that covers most day to day work. Reach for the COUNTIF and SUMIF versions when you need a number rather than a label, and remember the ampersand.
Other Excel articles you may also like:
