In this chapter
Using basic math functions in Excel
Reusing formulas in a spreadsheet
Using values or results from other sheets or files
Playing what-if to analyze figures
A spreadsheet would be mostly useless if all you could do with it was enter numbers and text in cells. The main purpose of a spreadsheet is to analyze information, and without formulas, most analysis would be impossible.
This chapter describes basic math functions and how to use them in Excel, as well as how to create formulas to manipulate and analyze the information in a spreadsheet.
Before you can start building formulas, you need to understand two key topics: cell references and operators. ...