|
Controlling formula display |
|
To change the layout and appearance of your formulas when they are displayed by MoboCalc, use the settings on the Display tab of the Options dialog.
Upper or lower case display
You can display functions, cells addresses, or both in either upper or lower case. You may find your formulas are easier to read if you display function names in one case and cell addresses in another, or you may prefer them to be all uppercase (the Excel default) or lowercase.
To set your display preferences for cell references and functions, select either the Uppercase or Lowercase options for Show cell addresses as and Show function names as on the Display tab.
Formula formatting
MoboCalc can display formulas in standard Excel notation, but it is much easier to understand the structure and meaning of your formulas if they are displayed in MoboCalc's formatted layout.
To select standard Excel notation, remove the check mark next to Display formatted formulas. When formatted formulas are disabled, you cannot set or use any of the other formatting options.
Formatting options
If Display formatted formulas is checked as recommended, division lines and exponents are shown when displaying formulas. By default, square root symbols and simplified logical expressions are also selected, but you can turn these off if you prefer.
You can use any of the following options to customize formula display.
Show simplified logical expressions. If you select this option, logical expressions are reordered so that AND and OR appear as inline operators rather than as functions. This is particularly useful for more complex logical tests.
Show functions as symbols. You can select the functions you want to display as symbols by placing a check mark next to them in the list box. Scroll down the list to see all the functions that can be represented by symbols.
See Entering formulas for examples of how each function appears when displayed as a symbol.
Your choices for display settings do not limit your ability to use symbols when entering functions. For example, you may prefer to enter the SUM function as a symbol but still have it displayed as SUM.
|