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

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

  1. Count the exact hits

    ABCD
    1TargetActual
    2552
    334
    488

    In D2: =DELTA(A2, B2)+DELTA(A3, B3)+DELTA(A4, B4) → 2

    Try this example

Common mistakes

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.

Translate a whole formula

Try DELTA in the playground

Related functions