13. Advanced Formula Writing and TroubleshootingOver the last five chapters you've learned how to use Excel's impressive function toolkit to calculate everything from statistical trend lines to a payment schedule for a home mortgage. Now that you've had a close look at these functions, it's time to consider a few techniques to help you get the most from your formulas. In this chapter, you'll tackle four new topics that deal with writing advanced formulas:
|