We can use the DELTA function to test if two numeric values are equal in both Excel & Google Sheet. When the values are equal, DELTA returns 1, else, DELTA returns zero.

=DELTA (num1, [num2])

**num1**– The first number. It can be directly entered or by cell reference.**num2**– [optional] The second number. It can be directly entered or by cell reference.

In the example below, we have used the DELTA function to check the equality of the numeric values ( which can be any number like integer, decimal, positive, negative) between each pair of cells in column A and B.

Like cell A2 is not equal to cell B2 hence the DELTA function returns 0 in cell C2. But cell A3 is equal to cell B3 hence the DELTA function returns 1 in cell C3.

Check the rest of the pairs to verify the result of the DELTA function.

#### Notes:

- If the 2nd number is left blank, DELTA assumes the second no. is equals to zero.
- If either value is text, DELTA returns #VALUE error.