The DELTA function tests whether two values are equal. It returns 1 if number1 = number2; returns 0 otherwise. You can use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.
Syntax: =DELTA (number1, [number2])
The DELTA function syntax has the following arguments:
- Number1 Required. The first number.
Number2 Optional. The second number. If omitted, number2 is assumed to be zero.
Example: Let’s look at some Excel DELTA function examples and explore how to use the DELTA function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following DELTA examples would return:
- If number1 is nonnumeric, DELTA returns the #VALUE! error value.
- If number2 is nonnumeric, DELTA returns the #VALUE! error value.