Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd Edition

Chapter 7

Using Basic Math Functions

In This Chapter

arrow Summing, rounding, and truncating values

arrow Using a value’s sign in a calculation

arrow Removing the sign from a number

Excel is excellent for working with advanced math and complex calculations. You can do so many complex things with Excel that it’s easy to forget that Excel is great at basic math, too.

Need the sum of a batch of numbers? No problem. Need to round a number? Read on! In this chapter, I show you not just how to sum and round numbers but how to use these methods in ways that give you just the answers you need.

Adding It All Together with the SUM Function

Just adding numbers together is something Excel is great at. Oh, you can use your calculator to add numbers as well, but think about it: On a calculator you enter a number, then press the + button, then enter another number, then press the + button, and so on. Eventually you press the = button and you get your answer. But if you made an entry mistake in the middle, you have to start all over!

The SUM function in Excel adds numbers together in a more efficient way. First, you list all your numbers on the worksheet. You can see them all and verify that they’re correct. Then ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book