Does LTE include the equal-to case, or does it work like < (less than)?

LTE includes equality. LTE(5, 5) returns TRUE because 5 is equal to 5. If you need only strictly less than (not including equal), use LT instead.

Can I use LTE to compare entire columns without specifying a range?

No, you must specify a range (e.g., C2:C100) or a single cell (e.g., C2). LTE does not work on entire columns implicitly. Google Sheets requires explicit range definitions to avoid ambiguity.

What happens if I compare a number to a blank cell with LTE?

Blank cells are treated as 0 in numeric comparisons. LTE(5, blank) returns FALSE (5 is not ≤ 0), and LTE(0, blank) returns TRUE. Use ISBLANK() first if you need to handle empty cells separately.

How do I combine LTE with FILTER to show only campaigns within budget?

Use =FILTER(A2:E5, LTE(C2:C5, 1000)) to return rows where spend (column C) is ≤ $1000. The LTE array feeds directly into FILTER's condition parameter, returning all campaigns that meet the threshold.

LTE function

Q: Does LTE include the equal-to case, or does it work like < (less than)?

LTE includes equality. LTE(5, 5) returns TRUE because 5 is equal to 5. If you need only strictly less than (not including equal), use LT instead.

Q: Can I use LTE to compare entire columns without specifying a range?

No, you must specify a range (e.g., C2:C100) or a single cell (e.g., C2). LTE does not work on entire columns implicitly. Google Sheets requires explicit range definitions to avoid ambiguity.

Q: What happens if I compare a number to a blank cell with LTE?

Blank cells are treated as 0 in numeric comparisons. LTE(5, blank) returns FALSE (5 is not ≤ 0), and LTE(0, blank) returns TRUE. Use ISBLANK() first if you need to handle empty cells separately.

Q: How do I combine LTE with FILTER to show only campaigns within budget?

Use =FILTER(A2:E5, LTE(C2:C5, 1000)) to return rows where spend (column C) is ≤ $1000. The LTE array feeds directly into FILTER's condition parameter, returning all campaigns that meet the threshold.

LTE checks if one value is less than or equal to another, returning TRUE or FALSE; use it to test spend, thresholds, or any numeric comparison.

=LTE(value1, value2)

Generate a LTE formula

Describe what you need. The generator will reach for LTE where LTE is the right tool, and tell you when it is not.

Arguments

How LTE reads its arguments

Argument	Required	Description
value1	Required	The value to check. Can be a number, text (compared alphabetically), date, or cell range. Compared as-is without conversion.
value2	Required	The threshold or comparison value. Same type constraints as value1; if types mismatch, LTE returns #VALUE!.

Returns

Boolean (TRUE or FALSE) for single values; array of booleans for ranges.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Check if campaign spend is within budget threshold

Campaign	Channel	Spend	Clicks	Conversions
Q1 Promo	Email	500	245	12
Spring Sale	Social	1200	890	45
Summer Flash	Search	800	1050	78
Fall Deal	Display	350	120	5

=LTE(C2:C5, 1000)

Result: {TRUE; FALSE; TRUE; TRUE}

Q1 Promo ($500), Summer Flash ($800), and Fall Deal ($350) all spent $1000 or less, so they return TRUE. Spring Sale ($1200) exceeded the threshold, so it returns FALSE. Use this array result in conditional logic or filtering to identify campaigns within budget.

2. Identify campaigns meeting minimum conversion targets

Campaign	Channel	Spend	Clicks	Conversions
Q1 Promo	Email	500	245	12
Spring Sale	Social	1200	890	45
Summer Flash	Search	800	1050	78
Fall Deal	Display	350	120	5

=IF(LTE(E2:E5, 50), "Check Performance", "Strong Performer")

Result: ["Check Performance", "Check Performance", "Strong Performer", "Check Performance"]

Campaigns with ≤50 conversions need attention. Q1 Promo (12), Spring Sale (45), and Fall Deal (5) all scored at or below 50, returning "Check Performance". Summer Flash (78) exceeded 50 conversions, so it's flagged as "Strong Performer". This pattern is useful for performance reviews and optimization prioritization.

3. Validate data integrity: ensure conversions don't exceed clicks

Campaign	Channel	Spend	Clicks	Conversions
Q1 Promo	Email	500	245	12
Spring Sale	Social	1200	890	45
Summer Flash	Search	800	1050	78
Fall Deal	Display	350	120	5

=LTE(E2:E5, D2:D5)

Result: {TRUE; TRUE; TRUE; TRUE}

Comparing each campaign's conversions (column E) to its clicks (column D), all rows return TRUE because conversions logically cannot exceed clicks. If any returned FALSE, it would signal a data entry error. This sanity check is critical for validating campaign metrics before analysis.

Common errors

Which LTE error are you seeing?

Error	Why it happens	How to fix it
#VALUE!	Attempting to compare incompatible types, such as text ("Email") with a number (500): =LTE("Email", 500).	Ensure both arguments are the same type. For mixed data, use IFERROR to handle the mismatch, or restructure your formula to compare only numbers or only text.
#NAME?	Misspelling the function name, such as =LESSTHANEQUAL(C2, 1000) or =LE(C2, 1000) instead of =LTE(C2, 1000).	Verify the function name is spelled exactly as LTE. Google Sheets is case-insensitive, but the name must be correct.
#NULL!	Providing ranges with incompatible dimensions, such as =LTE(C2:C5, D2:D4), where ranges have different numbers of rows.	Ensure both range arguments have the same dimensions. Use C2:C5 and D2:D5 (both 4 rows) rather than mismatched ranges.

Tips and when to use something else

LTE works with numbers, text, and dates; text is compared alphabetically ("Apple" < "Banana").
For checking multiple conditions at once (e.g., spend ≤ $1000 AND conversions ≥ 40), combine LTE with AND: =AND(LTE(C2,1000), GTE(E2,40)).
When LTE returns an array of TRUE/FALSE, use it directly in IF or FILTER, or wrap it with BYROW to apply logic row-by-row.
For simple "at most" checks on budgets or thresholds, LTE is often clearer than GT with NOT; prefer =LTE(spend, 1000) over =NOT(GT(spend, 1000)).

Related functions

LTReturns TRUE if the first value is strictly less than the second, FALSE otherwise; useful for conditional logic and filtering.GTGT tests whether the first value is strictly greater than the second value, returning TRUE if so and FALSE if not.GTEGTE returns TRUE when the first value is greater than or equal to the second, useful for filtering maintenance records by cost thresholds or mileage milestones.EQEQ returns TRUE if two values are exactly equal, FALSE otherwise. Use it to compare values in spreadsheet logic.IFThe IF function returns one value if a condition is true and another (or nothing) if it is false, letting you branch logic in a cell.

Frequently asked questions

Does LTE include the equal-to case, or does it work like < (less than)?: LTE includes equality. LTE(5, 5) returns TRUE because 5 is equal to 5. If you need only strictly less than (not including equal), use LT instead.
Can I use LTE to compare entire columns without specifying a range?: No, you must specify a range (e.g., C2:C100) or a single cell (e.g., C2). LTE does not work on entire columns implicitly. Google Sheets requires explicit range definitions to avoid ambiguity.
What happens if I compare a number to a blank cell with LTE?: Blank cells are treated as 0 in numeric comparisons. LTE(5, blank) returns FALSE (5 is not ≤ 0), and LTE(0, blank) returns TRUE. Use ISBLANK() first if you need to handle empty cells separately.
How do I combine LTE with FILTER to show only campaigns within budget?: Use =FILTER(A2:E5, LTE(C2:C5, 1000)) to return rows where spend (column C) is ≤ $1000. The LTE array feeds directly into FILTER's condition parameter, returning all campaigns that meet the threshold.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17