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

Chapter 14. Advanced Spreadsheeting > Advanced Formula Magic

14.2. Advanced Formula Magic

Chapter 12 covers the fundamentals of formulas—entering them manually, using the Calculator, and so on. The following section dives deeper into the heart of Excel's power—its formulas.


Note:

There's a difference between formulas and functions. A formula is a calculation that uses an arithmetic operator (such as =A1+A2+A3+A4+A5), while a function is a canned formula that saves you the work of creating a formula yourself (such as =SUM(A1:A5)).

Because there's no difference in how you use them, this chapter uses the terms interchangeably.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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