Chapter 9

Working with math functions

In this chapter, you will:

  • Discover Excel’s extensive collection of math worksheet functions

  • Understand when and how to use Excel’s worksheet functions for rounding numbers

  • Examine Excel’s worksheet functions related to summing values

  • Get to know the powerful and useful MOD() function

  • Learn various ways to generate random numbers

Excel’s mathematical underpinnings are revealed in the long list of math-related functions that come with the program. Functions exist for basic mathematical operations such as absolute values, lowest and greatest common denominators, square roots, and sums. Plenty of high-end operations also are available for things such as matrix multiplication, multinomials, and sums of squares. ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.