Functions
A function is a predefined formula for making a specific kind of calculation. Functions make it quicker and easier to write formulas.
For example, say you need to add up a column of numbers like the one in Figure 1 . It's perfectly acceptable to write a formula using cell references separated by the addition operator (+) like this:
=C4+C5+C6+C7+C8+C9+C10+C11+C12
Figure 1. Using the SUM function makes it easier to add up a range of numbers.
But rather than enter a lengthy formula, you can use the SUM function to add up the same numbers like this:
=SUM(C4:C12)
The SUM function is only one of over 200 functions built into Excel. I list all ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide 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.