ISMULTISELECT

This function returns TRUE if a referenced element is defined with multiselect XML, and FALSE if it is not. You might use ISMULTISELECT to determine, for example, 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("XML_multiselect")

Example

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

=ISMULTISELECT(C12)