Brackets in MPCData formulas

For an MPCData formula to be evaluated correctly, dimension member names should be enclosed by brackets or quotes. In contrast, cell references must not be enclosed by brackets or quotes. This rule prevents cell references from being mistaken for member names, and vice versa.

If a cell reference is enclosed by brackets or quotes, the cell reference is treated as a member name. If such a member name does not exist, no data is displayed. Similarly, if a member name that looks similar to a cell reference is not enclosed by brackets inside of quotes in the formula, the member name is treated as a cell reference. If no member name exists in the referenced cell, no data is displayed.