ISLEAF

ISLEAF returns 1 if a specified cell is a leaf cell (identified solely by leaf/simple elements). If the specified cell is identified by any consolidated elements, the function returns 0.

The ISLEAF function cannot be used in TurboIntegrator processes. The presence of this function in a process will prevent the process from compiling.

Syntax

ISLEAF

Arguments

None.

Example

You can use ISLEAF in an IF statement to test if a current cell is a leaf cell. For example:

[]=IF((ISLEAF=1),TrueStatement, FalseStatement);

Executes the TrueStatement if the current cell is a leaf cell, otherwise it executes the FalseStatement.