- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Creating Functions Using the Library
To make it easier to find the function you need for a specific use, Excel has organized functions into categories—such as Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, and other functions—on the Formulas tab. Functions—such as beta and chi-squared distributions—for the academic, engineering, and scientific community have been improved for more accuracy and includes new ones in all categories (
!) and web services (
!). Some statistical functions have been renamed for consistency with the real world. After you use a function, Excel places it on the recently used list. When you insert a function from the Function Library, Excel inserts the function in the formula bar and opens a Function Argument dialog box, where you can enter or select the cells you want to use in the function.
Enter a Function Using the Function Library
- Click the cell where you want to enter the function.
- Click the Formulas tab.
- Type = (an equal sign).
- Click the button (Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, More Functions, or Recently Used) from the Function Library with the type of function you want to use, click a submenu if necessary, and then click the function you want to insert into a formula.
Excel inserts the function you selected into the formula bar with a set of parenthesis, and opens the Function Arguments dialog box.
- Type the argument or select the cell or range you want to insert in the function.
You can click the Collapse Dialog button to the right of the text box, select the cell or range using your mouse, and then click the Expand Dialog button.
- Click OK.