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  

DELTA (number1, [number2])

Where number1 and [number2] are the two numbers whose equality is to be tested.

 

Example of DELTA Function in Excel

Formula:

DELTA Function in Excel 1

Result:

DELTA Function in Excel 2

 

NOTE: #VALUE! – Error occurs if

  • The supplied number arguments are non-numeric;

previous DELTA Function in Excel                                                                                                                next DELTA Function in Excel