Related Topics: | ||
Description: Returns either the start or end value of the time interval specified in the gap analysis of the data.
Syntax: GAP(Data_Src, Start/End)
Data_Src is the source data sheet from which the information is taken.
Start/End allows you to specify whether to return the start time or the end time of the gap interval.
Remarks:
The Data_Src can be one of the following values:
If using a default data source, it must be either 1, 2, 3 or 4, as selected from the Data Source Index drop-down list.
It can take a data sheet name (e.g., "Folio1!Data 1").
It can take a variable name defined in the Defined Names window (e.g., datasource).
Start/End is shown in the function as a numerical value that indicates the selected option: for the start time of the gap interval = 0; for the end time of the gap interval = 1.
Example:
GAP (“Gap Analysis!Gap Analysis”,0) = 500
Note that this value will vary depending on the source data set.
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.