O'Reilly logo

Excel Formulas and Functions For Dummies, 4th Edition by Ken Bluttman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19

Ten Functions You Really Should Know

In This Chapter

arrow Summing, averaging, and counting

arrow Rounding numbers

arrow Using IF for conditional results

arrow Using the current date and time

arrow Determining whether a value is a number

arrow Finding the smallest and largest values

arrow 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required