[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

GESTEP

Syntax:

GESTEP ( number [ , step ] )

Description: Tests if the value of number is greater than or equal to that of step.

Arguments:

Name

Type

Description

number

number

number is the value to test against step. If step is omitted, zero is used.

step

number

 

Return Type and Value: number – 1 if number ≥ step; otherwise, 0.

[Example:

GESTEP(5.6,-4.3) results in 1
GESTEP(5.6,5.6) results in 1
GESTEP(-5.6) results in 0

end example]