AWAIT
Pauses sheet calculation until all specified requests resolve. Please refer to AWAIT.ONE too.
Syntax
=AWAIT(CellReference1...CellReferenceN)
Arguments
| Name | Type | Description |
|---|---|---|
| CellReference1...CellReferenceN | Range | A list of cell-references or cell-ranges containing the requests to wait for. |
Return
| Type | Description |
|---|---|
| Boolean or Error | TRUE or an error if a cell reference is not valid. |
Examples
| Formula | Result | Comment |
|---|---|---|
| Waits for the request in A1 to resolve | |
| Waits for all requests to resolve | |
| Waits for the request in A1 and all requests in specified range to resolve |