O'Reilly logo

Excel Formulas and Functions For Dummies, 4th Edition by Ken Bluttman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required