Chapter 8

Advancing Your Math

In This Chapter

arrow Calculating the diameter, circumference, and area of a circle

arrow Returning random numbers

arrow Working with combinations and permutations

arrow Performing sophisticated multiplication

arrow Using the MOD function to test other numerical values

arrow Using the SUBTOTAL function for a variety of arithmetic and statistical totals

arrow Using the SUMIF and SUMIFS functions for selective summation

arrow 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 and Functions For Dummies, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.