9. Using Functions
This chapter shows you how to look up functions available in Excel and reviews some functions helpful for everyday use. Goal Seek is also introduced. Other tasks in this chapter include the following:
→ Using the Function Arguments dialog box
→ Using multiple criteria to look up values
→ Calculating the number of workdays between two dates
→ Creating formulas using multiple functions
A function is like a shortcut for using a long or complex formula. If you’ve ever summed cells using
=A1+A2+A3+A4+A5
you could have instead used the SUM function, like this:
=SUM(A1:A5).
Understanding Functions
Excel ...
Get My Excel 2016 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.
