DELTA Function

The DELTA function is used to check whether the given two numbers are exactly the same. It returns 1 if the numbers match and 0 if they do not match.
Note: This function works only for numbers. It displays #VALUE! for text.


Whereas C1 and C2 are the cells which contain the values that have to be compared.

Video Tutorial:

Let us find compare the given two numbers, using DELTA function, with the help of the below video

Learn MS Excel

Ask Questions

Ask Question