DELTA (test for equality)

<< Click to Display Table of Contents >>

DELTA (test for equality)

Syntax:

DELTA(Number1, Number2)

Description:

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. Text strings representing numbers are also allowed.

Example:

DELTA(1, 2) returns 0

DELTA(2, 2) returns 1

DELTA(2, "2") returns 1

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

See also:

EXACT