Chapter 8

Advancing Your Math


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

Bullet Returning random numbers

Bullet Working with combinations and permutations

Bullet Performing sophisticated multiplication

Bullet Using the MOD function to test other numerical values

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

Bullet Using the SUMIF and SUMIFS functions for selective summation

Bullet 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, 5th Edition now with O’Reilly online learning.

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