Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. 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.
| Excel version | Available |
|---|---|
| Excel 2007 | ✓ |
| Excel 2013 | ✓ |
| Excel 2019 | ✓ |
| Excel 2021 | ✓ |
| Microsoft 365 | ✓ |