Excel functions / Math
DELTA function
Tests whether two numbers are equal: 1 when they are, 0 when they are not.
Syntax
=DELTA(number1, [number2])
Arguments
number1: The first number.number2(optional): The second number. Left out, it is 0.
When to use it
DELTA gives 1 when two numbers are equal and 0 when they are not. Summed over a list, it counts exact matches.
Examples
Count the exact hits
A B C D 1 Target Actual 2 5 5 2 3 3 4 4 8 8 In D2:
=DELTA(A2, B2)+DELTA(A3, B3)+DELTA(A4, B4)→ 2
Common mistakes
- Text. DELTA takes numbers; text gives #VALUE!. Use = or EXACT for text.
DELTA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DELTA
- Danish: DELTA
- Dutch: DELTA
- Finnish: SAMA.ARVO
- French: DELTA
- German: DELTA
- Hungarian: DELTA
- Italian: DELTA
- Norwegian: DELTA
- Polish: CZY.RÓWNE
- Portuguese (Brazil): DELTA
- Portuguese (Portugal): DELTA
- Russian: ДЕЛЬТА
- Spanish: DELTA
- Swedish: DELTA
- Turkish: DELTA