The DELTA function tests whether two values are equal. DELTA returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function.

DELTA takes 1 required argument and 1 optional argument:

Syntax: DELTA(number1, [number2])

#1)
Using the DELTA function:
#2)
The arguments for the DELTA function are:
Argument Required? Description
number1 Required The first number.
number2 Optional The second number. If omitted, number2 is assumed to be zero.
#3)
A few more things:
If number1 is nonnumeric, DELTA returns the #VALUE! error value.
If number2 is nonnumeric, DELTA returns the #VALUE! error value.

Summary

The DELTA function tests whether two values are equal.
comments powered by Disqus