Chapter 12. Advanced Formula Writing


Over 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 that will help you get the most from your formulas.

In this chapter, you'll tackle four new topics that deal with writing advanced formulas:

  • How to use conditional logic with functions like SUMIF( ) and COUNTIF( ).

  • How to make formulas more readable by using named ranges.

  • How to control when your worksheets are recalculated.

  • How to solve mysterious errors by using Excel's formula auditing tools.



Excel. The Missing Manual
Excel 2010: The Missing Manual
ISBN: 1449382355
EAN: 2147483647
Year: 2003
Pages: 185

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net