Checks whether the specified values are equal.

Syntax  Copy Code
DELTA( Number x, [Number y = 0] ) → Number

Parameters

x

Required. The first number to compare.

y

Optional. The second number to compare. If omitted, y is assumed to be zero.

Remarks

If x and y are equal, returns 1; otherwise, 0. This function can be used to calculate the count of equal pairs by summing several DELTA functions.

Example

Formula  Copy Code
=DELTA(1,1) =DELTA(0,0.5)

See Also

Function Reference
EXACT function
GESTEP function