<< 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: