Microsoft Office Tutorials and References
In Depth Information
Chapter 8: Advancing Your Math
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 this in school.
Using PI to Calculate Circumference
and Diameter
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
symbol π.
Search JabSto ::

Custom Search