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 |