Chapter 10
Using Math Functions
IN THIS CHAPTER
Rounding off numbers in a spreadsheet
Using functions for calculating products, powers, and square roots
Summing the products in cell ranges or arrays
Doing conditional summing
The Math & Trig group of functions includes a wide variety of mathematical functions for computing new values as well as for controlling the results of calculations. This group also includes a large assortment of trigonometric functions most often needed in engineering and scientific endeavors. In this chapter, you get a chance to practice using some of the math functions more commonly needed in spreadsheets for business applications.
Rounding Off Values
Rounding off numbers that have fractions is one of the more frequent tasks you may undertake in Excel. Excel includes three functions in the Math & Trig category that you can use for rounding off the numbers in a worksheet:
- ROUND(number,num:digits) to round the value specified by the number argument to the number of digits specified by the num:digits argument
- ROUNDUP(number,num:digits) to round up the value away ...
Get Excel Workbook For Dummies, 2nd Edition 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.
