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 Value

TRUE or an error if a cell reference is not valid.

Example

Function

Comment

AWAIT(A1)

Waits for the request in A1 to resolve

AWAIT(A1, C4, F8)

Waits for all requests to resolve

AWAIT(A1, B2:C3)

Waits for the request in A1 and all requests in spcefied range to resolve