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