RepeatUntil
Repeats the execution of specified cells until either an exit condition becomes valid or the maximum number of iterations is reached.For more information, see Create a Loop of Spreadsheet Cells.
RepeatUntilInputs
Syntax: RepeatUntil(Event,Exit Condition,Max Iterations,Cells to Repeat)
Parameter | Description |
---|---|
Specifies the event on which to read thespecified Value. This parameter must be a reference to one of the following:
|
|
Specifies a non-zero value that defines the requirement to exit the repetitions. |
|
Specifies the maximum number of iterations (0 to 5000) that should be repeated. |
|
Specifies the reference to the cell or cells to be repeated.The reference must be a range of cells, a comma delimited list of cell references or a combination of the two. |
RepeatUntilOutputs
Returns |
A Loop data structurecontaining data about the repetition of the cells. |