DELTA function

Compares two numbers and returns 1 if they match, 0 if they differ; useful for conditional math and array-based counting.

=DELTA(number1, [number2])

Generate a DELTA formula

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

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How DELTA reads its arguments
number1requirednumber2optionalDELTA →
ArgumentRequiredDescription
number1RequiredThe first value to compare; can be a direct number, cell reference, or formula result.
number2OptionalThe second value to compare; optional and defaults to 0 if omitted.

Returns

A number: 1 (equal) or 0 (not equal).

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Check if a ticket has a specific priority level

Ticket IDPriorityAgent
10012Alice
10023Bob
10031Charlie
10042Charlie
=DELTA(C4, 2)

Result: 1

Cell C4 contains 2, and we're comparing it to 2, so DELTA returns 1 (they match). This pattern flags individual tickets meeting a priority threshold, and is often combined with IF to create readable labels.

2. Count all tickets with a given priority level

Ticket IDPriorityAgent
10012Alice
10023Bob
10031Charlie
10042Charlie
=SUMPRODUCT(DELTA(C2:C5, 2))

Result: 2

DELTA compares each cell in C2:C5 to 2, returning 1 for rows with priority 2 (tickets 1001 and 1004) and 0 for others. SUMPRODUCT sums these 1s and 0s, giving a total count of 2 matching tickets without needing a helper column.

3. Identify tickets with perfect customer satisfaction scores

Ticket IDCSATAgent
10015Alice
10024Bob
10033Charlie
10045Charlie
=DELTA(F2, 5)

Result: 1

The first ticket has a CSAT of 5. DELTA(5, 5) returns 1, indicating perfect satisfaction. Nest this in IF to create conditional labels: =IF(DELTA(F2, 5), "Perfect", "Review needed"), making satisfaction tiers automatic.

Common errors

Which DELTA error are you seeing?
DELTA returned an error#VALUE!
Ensure both arguments are numbers or cells containing numbers. For text equality checks, use EXACT instead. Convert text to numbers with VALUE() if needed.
#N/A
Locate and repair the error in the source cell. Alternatively, wrap the formula in IFERROR or IFNA to suppress and handle the error gracefully.
#REF!
Update the formula to reference valid cells, or restore the deleted rows/columns if they were removed accidentally.
ErrorWhy it happensHow to fix it
#VALUE!One or both arguments contain non-numeric data, such as text, dates stored as text, or a formula returning an error.Ensure both arguments are numbers or cells containing numbers. For text equality checks, use EXACT instead. Convert text to numbers with VALUE() if needed.
#N/AA referenced cell contains an error like #REF!, #DIV/0!, or another #N/A, which propagates through DELTA.Locate and repair the error in the source cell. Alternatively, wrap the formula in IFERROR or IFNA to suppress and handle the error gracefully.
#REF!A cell reference in the formula points to a deleted row or column, so the reference is no longer valid.Update the formula to reference valid cells, or restore the deleted rows/columns if they were removed accidentally.

Tips and when to use something else

  • DELTA returns numeric 1 or 0, not TRUE/FALSE. This makes it ideal for SUMPRODUCT and array formulas where you need to count matches without helper columns.
  • For text comparisons, use EXACT(text1, text2) instead. EXACT is case-sensitive; DELTA only works with numbers.
  • If number2 is omitted, it defaults to 0. So =DELTA(5) returns 0 and =DELTA(0) returns 1. This is handy for testing whether a value is zero.
  • When you need multiple conditions or outcomes, IF, SWITCH, or AND/OR may be clearer than nested DELTA calls; choose based on readability.

Related functions

EXACTEXACT returns TRUE if two text strings are exactly the same, including case, and FALSE otherwise, making it ideal for case-sensitive comparisons.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.SUMPRODUCTSUMPRODUCT multiplies arrays element-by-element and sums the results, useful for weighted totals and multi-criteria counting.GESTEPReturns 1 if a number is greater than or equal to a step value, 0 otherwise; ideal for flagging or counting values meeting a threshold.

Frequently asked questions

What's the difference between DELTA and the equals operator (=)?
The equals sign (=) inside an IF statement returns TRUE or FALSE. DELTA returns numeric 1 or 0, making it suitable for math operations and counting. For example, =SUM(IF(A1=A2, 1, 0)) and =DELTA(A1, A2) both count matches, but DELTA is more concise.
Can DELTA compare text values?
No. DELTA is numeric-only and will return #VALUE! if given text. For text equality, use EXACT(text1, text2), which returns TRUE for identical strings (case-sensitive) and FALSE otherwise.
What happens if I omit the second argument in DELTA?
If number2 is omitted, DELTA defaults to comparing with 0. So =DELTA(5) equals 0 (since 5 ≠ 0), and =DELTA(0) equals 1 (since 0 = 0). This is a shorthand for testing whether a value is zero.
How is DELTA more useful than a simple IF formula?
In array formulas like =SUMPRODUCT(DELTA(range, value)), DELTA shines because it returns numeric 1/0 that sum cleanly. SUMPRODUCT with IF requires more syntax: =SUMPRODUCT(IF(range=value, 1, 0)). For single checks, IF is often more readable; for counting matches, DELTA is more elegant.

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