Quick Navigation
DELTA Function
Summary
The DELTA function tests whether two numbers are equal, returning 1 for exact matches and 0 otherwise. Known as the Kronecker Delta in mathematics, it's perfect for filtering datasets, counting matches, and creating conditional indicators in Excel analysis.
Syntax
DELTA(number1, [number2])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number1 | Number |
Yes | First number for comparison - required parameter |
| number2 | Number |
No | Second number for comparison - optional, defaults to 0 |
Using the DELTA Function
DELTA excels at simplifying equality checks across datasets. Use it to count matching records, filter results by exact value matches, or create binary indicators (1/0) for further analysis like SUMPRODUCT operations or conditional aggregation.
Common DELTA Examples
Basic Equality Check
=DELTA(5,5)Returns 1 because both values match exactly.
Non-Matching Values
=DELTA(5,4)Returns 0 since 5 doesn't equal 4.
Default Zero Comparison
=DELTA(0.5)Returns 0 because 0.5 doesn't equal the default 0.
Counting Matches in Range
=SUMPRODUCT(--(DELTA(A1:A10,B1:B10)))Counts how many pairs match exactly between two ranges.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! Error
Cause: Either number1 or number2 contains non-numeric data
Solution: Ensure both parameters contain valid numbers or numeric references
Notes
- Also called Kronecker Delta function from mathematics
- Perfect companion for SUMPRODUCT match counting
- Use in array formulas: {SUM(DELTA(range1,range2))}
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+