In this chapter, we will look at a useful technique that combines several functions into a single formula. We can call it a megaformula. In other words, we have one or more functions nested inside other functions. The use of megaformulas is a contentious issue. Some people claim that having multiple intermediate formulas results in a clearer understanding of what is happening as compared to having a single complex formula. As a user, it’s your call as to whether megaformulas would be helpful in your scenario.
What Is a Megaformula?
Many times, we use intermediate formulas in a worksheet ...
