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