Chapter 19
Ten Functions You Really Should Know
In This Chapter
Summing, averaging, and counting
Rounding numbers
Using IF for conditional results
Using the current date and time
Determining whether a value is a number
Finding the smallest and largest values
Using conditional summing and counting
This chapter lists the top ten Excel functions. Actually, it lists the top 15, but in some cases two related functions are treated as a single item. To be fair, there is no absolute top ten list of functions, but over the years (donât ask how many!) I have worked on hundreds of worksheets and saw some of the same functions used all the time.
The functions in this list are of the type that apply to a wide array of needs. You wonât see a financial function or any advanced statistical function ...
Get Excel Formulas and Functions For Dummies, 3rd Edition 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.