Microsoft Office Tutorials and References
In Depth Information
Chapter 8: Advancing Your Math
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 in school.
Using PI to Calculate Circumference
Pi is the ratio of a circle’s circumference to its diameter. A circle’s
circumference is its outer edge and is equal to the complete distance around the circle.
A circle’s diameter is the length of a straight line spanning from one side of
the circle, through the middle, and reaching the other side.
Dividing a circle’s circumference by its diameter returns a value of
approximately 3.14159, known as pi. Pi is represented with the Greek letter pi and the