Functions for Mathematical Calculations

This is the largest category of the functions described in this chapter. This category is divided into the following subcategories:

  • Standard arithmetic operations Besides addition, subtraction, multiplication, and division functions, this chapter also explains the functions for exponentiation, root extractions, and logarithmic calculus. The arithmetic operations covered in this chapter provide the basis for algebraic calculations.

  • Rounding The usual mathematical principle is for all values less than five to be rounded down and all values greater than or equal to five to be rounded up. However, there are several reasons to deviate from this principle. For example, you might want to round prices to a multiple ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.