beautypg.com

Gestep, 88 gestep – Apple iWork '09 User Manual

Page 88

background image

Related Topics
For related functions and additional information, see:

“ERF” on page 87

“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

GESTEP

The GESTEP function determines if one value is greater than or exactly equal to
another value. This function uses exact equality. By comparison, the = operator uses
string-based equality.

GESTEP(compare-num, step-number)

Â

compare-num: The number to compare. compare-num is a number value.

Â

step-number: The size of the step. step-number is a number value.

Usage Notes

GESTEP returns 1 (TRUE) if

Â

compare-num is greater than or exactly equal to step-

number; otherwise 0 (FALSE) is returned.

Examples

=GESTEP(-4, -5) returns 1 (TRUE), since -4 is greater than -5.
=GESTEP(4, 5) returns 0 (FALSE), since 4 is less than 5.
=GESTEP(5, 4) returns 1 (TRUE), since 5 is greater than 4.
=GESTEP(20, 20) returns 1 (TRUE), since 20 is exactly equal to 20.

Related Topics
For related functions and additional information, see:

“DELTA” on page 86

“Listing of Engineering Functions” on page 72

Value Types” on page 36

The Elements of Formulas” on page 15

88

Chapter 5

Engineering Functions