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.

Formula:


=DELTA(C1,C2)
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