The DELTA function determines whether two number values are exactly equal. This function uses exact equality. By comparison, the = comparison operator uses string-based equality.
DELTA(compare-from, compare-to)
compare-from: A number value representing one of the numbers being compared.
compare-to: A number value representing the other number being compared.
Notes
DELTA returns 1 (equivalent to the boolean value TRUE) if compare-from is exactly equal to compare-to; otherwise 0 (equivalent to the boolean value FALSE) is returned.
Examples |
|---|
=DELTA(5, 5) returns 1 (TRUE). =DELTA(5, -5) returns 0 (FALSE). =DELTA(5, 5.000) returns 1 (TRUE). |