DEPENDS function

This article describes the formula syntax of the DEPENDS function.

Description

Return cell after dependent is calculated.

Syntax

DEPENDS(cell, dependent)

cell	is the cell to return.
dependent	is the dependent cell.

The DEPENDS function is used to force the calculation order of cells. The first argument cell will be calculated after the dependent cell is evaluated. This is useful when using handles since some functions return unchanged handles so Excel cannot keep track of dependencies in the usual way.