DELTA

Tests whether two values are equal. 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.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

DELTA(number1,number2)

Number1   is the first number.

Number2   is the second number. If omitted, number2 is assumed to be zero.

Remarks

• If number1 is nonnumeric, DELTA returns the #VALUE! error value.
• If number2 is nonnumeric, DELTA returns the #VALUE! error value.

Examples

DELTA(5, 4) equals 0

DELTA(5, 5) equals 1

DELTA(0.5, 0) equals 0