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:

NOTE: #VALUE! – Error occurs if

The supplied number arguments are non-numeric;