Excel DELTA Function

Using the Excel DELTA Function

Excel DELTA Function

Summary

The Excel DELTA function is used to test whether two values are equal. The function returns 1 if number1 = number2 and 0 in all other cases.

DELTA is a useful function if you need to filter a set of values or easy count pairs of equal numbers.

Syntax

=DELTA (number1, [number2])

Syntax Breakdown

Number1
Required. First number.

Number2
Optional. If omitted, it is assumed to be 0 (zero).

Usage Notes

DELTA tests two numeric values to determine if they are equal. If the values are equal, the function returns 1. If the values are not equal, the function returns 0.

DELTA Errors
DELTA returns the #VALUE! error if number1 or number2 is non-numeric.