Chapter 9. Performing Basic Math

The Basics of Formulas in Excel

You can use Excel to make life much easier when it comes to performing math. Many people consider the math capabilities in Excel to be the heart of the program. Using formulas, you can perform myriad calculations to analyze data in your worksheet.

You can enter formulas by using either of two methods: You can simply type the formula or you can use the mouse and click cells to include in the formula. Later in this chapter, in the sections "Add Numbers" and "Multiply Numbers," you see examples of using both techniques.

Constants and Cell References

You typically use formulas to perform basic math — add, subtract, multiply, and divide numbers — but you can also calculate percentages and ...

Get Master VISUALLY® Excel® 2010 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.