AWAIT.ONE
Pauses sheet calculation until at least one of specified requests resolves. Please refer to AWAIT too.
Syntax
=AWAIT.ONE(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 one request to resolve | |
| Waits for request in A1 and or one of the requests in specified range to resolve |