Description Compares two specified values and returns 1 if they are equal, 0 if they are not.
Syntax DELTA (number1 [, number2])
| Argument | Description |
|---|---|
| number1 | A number you want to compare. |
| [number2] | Optional. This is the number you want to compare to number1. If you omit this argument, the function will compare number1 to 0. |
Remarks This function can be used in place of the equals (=) operator when a numeric rather than logical result is needed (for example, when using aggregate functions such as SUM and COUNT).
This function is sometimes referred to as the Kronecker Delta function.
Examples This function returns 0:
This function returns 1:
