DELTA (test for equality)

<< Click to Display Table of Contents >>

DELTA (test for equality)

Syntax:

DELTA(Number1, Number2)

Description:

This tests if two values are equal. If they are, 1 is returned, otherwise 0 is returned.

Number1 and Number2 must be numbers, otherwise a #VALUE! error value is returned.

However, text strings that are returned when using the TEXT function or some conversion functions, for example, are also permitted. The text strings may only contain numeric values.

Example:

DELTA(1, 2) returns 0

DELTA(2, 2) returns 1

DELTA(2, "2") returns 1

DELTA("Text", "Text") returns the #VALUE! error value

See also:

EXACT