DELTA

Checks whether the specified values are equal.

Syntax

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

=DELTA(1,1)
=DELTA(0,0.5)

See Also

Function Reference
EXACT function
GESTEP function