Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 11. Working with Math Functions

IN THIS CHAPTER

• Understanding Excel’s Rounding Functions 247

• Rounding Billable Time 253

• Summing Values 253

• The MOD() Function 255

• Generating Random Numbers 259

Excel’s mathematical underpinnings are revealed when you consider 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. Not all of Excel’s math functions are useful in a business context, but a surprising number of them are. For example, operations such as rounding and generating ...