O'Reilly logo

Excel Formulas & Functions For Dummies, 5th 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

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

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