Chapter 18. From Simple Addition to What-ifs: Formulas
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.
Understanding Cell References and Operators
Before you can start building formulas, you need to understand two key topics: cell references and operators. ...
Get Absolute Beginner’s Guide to Microsoft® Office 2003 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.
