ISMULTISELECT

ISMULTISELECT returns True if a referenced element is defined with multiselect XML, and False if it is not. You might use ISMULTISELECT to determine whether writeback is allowed on a specific cell. You cannot writeback on a cell that is defined with multiselect XML because such cells are locked.

Syntax

=ISMULTISELECT("multiselect XML")

Example

In this example, cell C12 contains a multisselect XML variable that was created with MULTISELECTCREATE and populated with MULTISELECTADD. The formula returns True.

=ISMULTISELECT(C12)