Microsoft Office Tutorials and References
In Depth Information
Figure 21-8: This workbook uses a megaformula to generate realistic random names.
The Pros and Cons of Megaformulas
If you followed the examples in this chapter, you probably realize that the main advantage of creating a mega-
formula is to eliminate intermediate formulas. Doing so can streamline your worksheet, reduce the size of your
workbook files, and may even result in slightly faster recalculations.
The downside? Creating a megaformula does, of course, require some additional time and effort. And, as you've
undoubtedly noticed, a megaformula is virtually impossible for anyone (even the author) to figure out. If you
decide to use megaformulas, take extra care to ensure that the intermediate formulas are performing correctly
Search JabSto ::

Custom Search