Chapter 9
Playing with Formulas
IN THIS CHAPTER
Creating, using, and editing formulas
Conditional formatting
Manipulating data with Goal Seeking
Creating multiple scenarios
Auditing formulas
Validating data
What makes Excel useful is its capability to manipulate data by using formulas. Formulas can be as simple as adding two or more numbers or as complicated as calculating data from other formulas so that changes in a single cell can ripple throughout an entire spreadsheet.
Creating a Formula
Formulas consist of three crucial bits of information:
- An equal sign (=)
- One or more cell references
- The type of calculation to do on the data (addition, subtraction, and so on)
The equal sign (=) simply tells Excel not to treat the formula as text but as instructions for calculating something. ...
Get Office 2019 For Dummies 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.
