DELTA Function in Excel tests the equality of two numbers. DELTA Function returns 1 if the two supplied numbers are equal and returns 0 if two of the numbers are not equal.
Syntax of DELTA Function in Excel
DELTA (number1, [number2])
Where number1 and [number2] are the two numbers whose equality is to be tested.
Example of DELTA Function in Excel
Formula:
Result:
NOTE: #VALUE! – Error occurs if
- The supplied number arguments are non-numeric;