Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 14. Building Advanced Workbooks > Advanced Formula Magic
14.4. Advanced Formula Magic
Chapter 13 covered the fundamentals of formulas—entering them manually, using the Formula Builder, and so on. The following section dives deeper into the heart of Excel’s mathematical power—its formulas.
Note:
Technically, 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.
