DELTA


Returns 1 if two numbers are equal, and 0 otherwise.

Syntax:

DELTA(number1, number2)

number1 and number2 are numbers. If number2 is omitted it is assumed to be 0. This function is an implementation of the (mathematical) Kronecker delta function. number1=number2 returns TRUE or FALSE instead of 1 or 0, but is otherwise identical for number arguments.

Example:

DELTA(4, 5)
returns 0.
DELTA(4, A1)
where cell A1 contains 4, returns 1.
DELTA(0)
returns 1.
=4=5
in a cell shows FALSE, as 4 is not equal to 5.






 
Created with Zapof