February 2013
Beginner
408 pages
9h 10m
English
Chapter 8
Advancing Your Math
In This Chapter
Calculating the diameter, circumference, and area of a circle
Returning random numbers
Working with combinations and permutations
Performing sophisticated multiplication
Using the MOD function to test other numerical values
Using the SUBTOTAL function for a variety of arithmetic and statistical totals
Using the SUMIF and SUMIFS functions for selective summation
Getting an angle on trigonometry functions
In this chapter, I show you some of the more advanced math functions. You won’t use these functions every day, but they’re just the right thing when you need them. Some of this will come back to you because you probably learned most of this ...