Delta, 86 delta – Apple iWork '09 User Manual

Page 86

Advertising
background image

“HEX2OCT” on page 91

“OCT2DEC” on page 94

“Listing of Engineering Functions” on page 72

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

DELTA

The DELTA function determines whether two values are exactly equal. This function
uses exact equality. By comparison, the = operator uses string-based equality.

DELTA(compare-from, compare-to)

Â

compare-from: A number. compare-from is a number value.

Â

compare-to: A number. compare-to is a number value.

Usage Notes

DELTA returns 1 (TRUE) if

Â

compare-from is exactly equal to compare-to; otherwise

0 (FALSE) is returned.

Examples

=DELTA(5, 5) returns 1 (TRUE).
=DELTA(5, -5) returns 0 (FALSE).
=DELTA(5, 5.000) returns 1 (TRUE).

Related Topics
For related functions and additional information, see:

“GESTEP” on page 88

“Listing of Engineering Functions” on page 72

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

86

Chapter 5

Engineering Functions

Advertising