CONTINUE
Continue current calculation at given cell. Note that if specified cell is before current cell the calculation is continued on next step. Normally a Streamsheet is calculated from left to right and top to bottom. Using CONTINUE you can jump within the calculation logic.
Syntax
=CONTINUE(Cell)
Arguments
| Name | Type | Description |
|---|---|---|
| Cell | Cell | Target cell of CONTINUE. |
Return
| Type | Description |
|---|---|
| Boolean or Error | TRUE, if successful, otherwise error code. |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | The step stops at the CONTINUE() function, jumps back to B1 and starts the next step at B1. |
danger
Be careful, when using CONTINUE, as you can define an endless loop using this function.