Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Ten Functions You Really Should Know
Ten Functions You Really
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 — just
the basics — but knowing the functions in this chapter is essential to good
Excel work. You can always refer here for a quick brush-up on how to use
these important functions.
Adding numbers is one of the most basic mathematical operations. And so
there is the SUM function dedicated to doing just that. SUM takes up to 255
Each argument can be a single number or a range containing multiple numbers.
That means SUM can add up a whole bunch of numbers! The syntax follows: