Using Formulas and Functions
- Understanding Formulas and Cell References in Excel
- Creating Simple Cell Formulas
- Assigning Names to Groups of Cells
- Using Names in Formulas
- Creating a Formula That References Values in an Excel Table
- Creating Formulas That Reference Cells in Other Workbooks
- Summing a Group of Cells Without Using a Formula
- Creating a Summary Formula
- Summing with Subtotals and Grand Totals
- Exploring the Excel Function Library
- Using the IF Function
- Checking Formula References
- Debugging Your Formulas
Exploring the Excel Function Library
You can create dozens of different functions in Excel. You can use Excel functions to determine mortgage payments, perform scientific calculations, or find the square root of a number. The best way to become familiar with the formulas available in Excel is to display the Insert Function dialog box and move through the listed functions, clicking the ones that look interesting. When you click a function, its description appears at the bottom of the dialog box.
Another way to get information about a function is to view the ScreenTip that appears next to the function. If you double-click a cell with a function, a ScreenTip with the function’s structure and expected values appears below it. Clicking an element of the structure points to the cell or cells providing that value.
List Functions Available from the Excel Library
Click the Insert Function button.
Display the drop-down list, and click the function category you want to view.
Click the function you want to examine.
Click Cancel to close the Function Arguments dialog box.
Use Function ScreenTips
Double-click a cell that contains a formula.
In the ScreenTip, click the function name to open the Help file entry for the function.
Click the Close button to close the Help window.
Click an argument to select the cells to which it refers.