DEPENDS function

This article describes the formula syntax of the DEPENDS function.


Return cell after dependent is calculated.


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.