DELTA

Math & Trig

Tests whether two values are equal. Returns 1 if equal, 0 if not.

Translations

EnglishDELTA

FrenchDELTA

SpanishDELTA

GermanDELTA

ItalianDELTA

PortugueseDELTA

DutchDELTA

PolishDELTA

RussianДЕЛЬТА

TurkishDELTA

CzechDELTA

HungarianDELTA

SwedishDELTA

DanishDELTA

FinnishDELTA

Syntax

DELTA(number1, [number2])

Examples

=DELTA(5,5)

Values are equal

=DELTA(5,4)

Values differ

=SUMPRODUCT(DELTA(A1:A10,B1:B10))

Count matches

Count exact matches

Tips & Best Practices

Common Mistakes

•Using DELTA to compare text values, expecting a meaningful result - it's designed for numbers only, and comparing text can produce unexpected results or errors
•Forgetting that DELTA returns 1 or 0, not TRUE or FALSE, which matters if the result feeds into a formula expecting a genuine logical value
•Overlooking that number2 defaults to 0 when omitted, so DELTA(A1) is really testing whether A1 equals zero, not comparing it to a blank cell

Related Functions

EXACTPerforms a case-sensitive comparison for text values, the text equivalent of what DELTA does for numbers.

IFCan replicate DELTA's logic with IF(number1=number2,1,0), though DELTA is more compact for this specific numeric-equality case.

SUMPRODUCTFrequently combined with DELTA to count how many pairs of values in two ranges match exactly.

Frequently Asked Questions

Does DELTA work with text values?

It's designed for numbers - using it on text can give unreliable results, so use EXACT instead for comparing text.

Does DELTA return TRUE or FALSE?

No, it returns 1 for equal and 0 for not equal, which is useful for direct use in sums but different from a genuine logical value.

What happens if I only give DELTA one number?

The second number defaults to 0, so DELTA(A1) checks whether A1 equals zero rather than comparing it to nothing.

Use our translator to convert your complete formula