Creating Excel Formulas and Functions
In This Chapter
Writing basic formulas
Copying and moving formulas
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 ...