Chapter 8
Advancing Your Math
IN THIS CHAPTER
Calculating the circumference, diameter, 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 ...
Get Excel Formulas & Functions For Dummies, 6th 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.
