ISEXPANDED

This function, in the data cell of a hyperblock, returns TRUE for each element that is expanded in the hyperblock.

Syntax

ISEXPANDED(reference)

Example

A hyperblock in cells C7:D7 displays a hierarchical list. This function, in D7, returns expand state of each element in the list:

=ISEXPANDED(C7)