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

Chapter 3. Formula Annoyances

Chapter 3. Formula Annoyances

Transforming the data in your worksheets using formulas is what Excel does best. What could be annoying about that? Lots! Take one horrible example: consider what happens when you create a formula in one cell and copy it to another cell. If you don't build the formula just right, the cell references in the formula might change based on where you pasted the copied formula! I'll show you how to prevent this and other annoyances from happening.

Dates and times can present significant challenges in formulas. The arithmetic isn't particularly hard—it just doesn't always work the way you'd expect it to. Excel uses an exotic numerical system to refer to dates that seems totally arbitrary. But don't worry: you'll learn how to deal with this and other Excel quirks by the time you finish this chapter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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