Chapter 19

Ten Functions You Really Should Know


Bullet Summing, averaging, and counting

Bullet Rounding numbers

Bullet Using IF for conditional results

Bullet Using the current date and time

Bullet Determining whether a value is a number

Bullet Finding the smallest and largest values

Bullet 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 have seen some of the same functions being 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 ...

Get Excel Formulas & Functions For Dummies, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.