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