• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

II. Formulas and Functions > 12. Advanced Formula Writing

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.

Conditions in Formulas


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint