O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

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 5: Math and Statistical Formulas

In This Chapter

arrow.png Rounding off numbers

arrow.png Raising numbers to powers and finding square roots

arrow.png Conditional summing

arrow.png Using basic statistical functions, such as AVERAGE, MIN, and MAX

arrow.png Building formulas that count

arrow.png Using specialized statistical functions

This chapter examines two larger categories of Excel functions: Math & Trig and statistical functions. The Math & Trig functions are found on the Math & Trig command button’s drop-down menu on the Ribbon’s Formulas tab (the button with the q on the book cover). This category includes all the specialized trigonometric functions such as those that return the sine, cosine, or tangents of various angles and logarithmic functions (for finding the base-10 and natural logarithms of a number), along with the more common math functions for summing numbers, rounding numbers up or down, raising a number to a certain ...

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