Chapter 4. Formulas and Functions

Chapter 3, explained the basics of editing formulas. However, you will quickly reach a point where the formulas for calculations get more complicated. An example is the summation in Figure 4-1. Do you really want to type such a long formula?

Who wants to enter such a long formula to add something up?

Figure 4-1. Who wants to enter such a long formula to add something up?

What if you need to add up not 12 but 100 or more numbers? At this point, you should learn about functions. In this specific case, the Microsoft Excel SUM() function simplifies the formula (see Figure 4-2). Chapter 16, includes a detailed description ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.