Formulas and Functions
Modifying this control will update this page automatically

DELTA

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).

See alsoGESTEP
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.