DELTA Function in Excel – Test the Equality of two numbers

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  

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;