Syntax
DELTA(number1, [number2])
| Parameter | Description |
|---|---|
| number1 | Parameter of the DELTA function. |
| [number2] | (Optional.) Parameter of the DELTA function. |
Examples
Test equality of two values
Formula
=DELTA(5, 5)
1. Both numbers are equal, so DELTA returns 1.
Test inequality
Formula
=DELTA(5, 4)
0. The numbers differ, so DELTA returns 0.
Count exact matches in a range
Formula
=SUMPRODUCT(DELTA(A1:A20, 100))
Returns the count of cells in A1:A20 that exactly equal 100. DELTA returns 1 for each match, and SUMPRODUCT adds them up.
Common Errors
#VALUE!
One or both arguments is non-numeric text.
Tips
DELTA vs equals comparison
DELTA(a, b) returns 1 or 0 (numbers), while a=b returns TRUE or FALSE (logical). Use DELTA when you need a numeric result for further calculations.
Single argument tests against zero
DELTA(5) is equivalent to DELTA(5, 0) — it tests whether the number equals zero. Useful for checking if a calculation zeroed out.
Pair with SUMPRODUCT
=SUMPRODUCT(DELTA(range, target)) is a clean way to count exact matches without COUNTIF. It works well in array formula contexts.
Try DELTA in Viztab
Import your data and use DELTA with 370+ other formulas. No signup required.
Open Viztab