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 ...
Get Excel Formulas and Functions For Dummies, 3rd 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.