Text View – the formula as it appears in Excel’s Formula Bar
Math View – a typographical view to aid recognition
Click here to see a Math View of your formula.
Tree View – a structural view to
display interim values
expand and collapse subexpressions
Synchronized views help you see the structure of your formula and allow you to concentrate on portions of particular interest. Coordinated highlighting links subexpressions among the views. FormulaView lets you substitute ellipses (…) or values for collapsed subexpressions to further simplify the display.
FormulaView reduces errors in Excel® spreadsheets