Microsoft Office Tutorials and References
In Depth Information
Looking It Up
Figure 14-14:
Using
FORMULATEXT to see
the syntax
of formulas.
There is a setting in Excel’s options to always display formulas as syntax
instead of showing the calculated results. Look in the Display options for this
worksheet on the Advanced tab in Excel Options to see where this option is
set. This setting converts all formulas into text, and you can see them all. The
caveat in using this approach is no calculations occur! If you need to see all
the calculations’ inner workings, then this is a good option. However, if you
wish to still have the formulas calculate answers, and want to see how they
are written, use FORMULATEXT.
NUMBERVALUE
NUMBERVALUE is used to format numbers that appear as text back to
appearing as actual numbers. For example, your worksheet might display
a value such as “14.25%”. Excel will treat this correctly as a number if used
in a formula, function, or calculation, but the percent sign is not part of the
number. Remember a percent is usually a decimal-based number. The 14.25
percent when not formatted is .1425.
Search JabSto ::




Custom Search