AWAIT
Pauses sheet calculation until all specified requests resolve. Please refer to AWAIT.ONE too.
Syntax
=AWAIT(CellReference1...CellReferenceN)
Arguments
| Name | Description |
|---|---|
| CellReference1...CellReferenceN | A list of cell-references or cell-ranges containing the requests to wait for. |
Return
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 |