WorksheetFunction.Delta Method
| Excel Developer Reference |
Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise.
Syntax
expression.Delta(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | Number1 - the first number. |
| Arg2 | Optional | Variant | Number2 - the second number. If omitted, number2 is assumed to be zero. |
Return Value
Double
Remarks
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.
- If number1 is nonnumeric, DELTA returns the #VALUE! error value.
- If number2 is nonnumeric, DELTA returns the #VALUE! error value.
See Also