View the structure of formulas

The Function wizard allows you to view the structure of complex formulas in a separate window. To open the formula structure window, click Open formula structure in the Function arguments window.

If necessary, you can adjust the width and height of the window as follows:

–To increase or decrease the window width, move its right border to the left or right.

–To increase or decrease the window height, move its bottom border up or down.

–To adjust the window width and height simultaneously, move its bottom right corner in the desired direction.

The formula structure displays all the arguments it contains and their values in a tree view. You can show or hide arguments nested within functions. To do this, use or structure symbols:

Formulas and arguments containing errors are marked with the symbol. Instead of a value, the error type is displayed for them:

To close the window containing the structure, click OK or the button in the window title bar.