O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required