Chapter 8
Creating Excel Formulas and Functions
In This Chapter
Writing basic formulas
Copying and moving formulas
Inserting functions
Showing the current date or time with a function
Calculating loan terms
Evaluating a condition with an IF function
Referring to named ranges
Using the Quick Analysis feature
Math. Excel is really good at it, and it’s what makes Excel more than just data storage. Even if you hated math in school, you might still like Excel because it does the math for you.
In Excel, you can write math formulas that perform calculations on the values in various cells, and then, if those values change later, you can see the formula results update automatically. You can ...
Get Office 2016 at Work 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.