Formulas and functions > Functions from A to Z

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. Strings that contain only one number 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

DELTA (test for equality)