Skip to Main Content
Office for iPad and Mac For Dummies
book

Office for iPad and Mac For Dummies

by Peter Weverka
March 2015
Beginner to intermediate content levelBeginner to intermediate
384 pages
8h 17m
English
For Dummies
Content preview from Office for iPad and Mac For Dummies

Chapter 19

Ten-Plus Functions for Crunching Numbers

In This Chapter

arrow Tabulating data with functions

arrow Using functions to clean up data

arrow Comparing values with functions

arrow Calculating loan payments with the PMT function

arrow Measuring time with functions

Excel offers more than four hundred different functions. I choose what I consider the most useful and most interesting functions for this chapter.

If you’re not familiar with functions, check out Chapter 11. It explains how functions work, what function arguments are, how to enter arguments with functions, and how to include functions in formulas.

AVERAGE for Averaging Data

Might as well start with an easy one. The AVERAGE function averages the values in a cell range. In Figure 19-1, for example, AVERAGE is used to compute the average rainfall in a three-month period in three different counties.

image

Figure 19-1: Using AVERAGE to find average ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 9781119010180Purchase book