This how-to guide includes 3 operation topics, and all 3 are available without membership; choose a topic from the index and follow the entry path and steps to complete the task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Enter the function from the Insert Function dialog | Free |
| 2 | 2. Type the formula directly in a cell | Free |
| 3 | 3. Review the syntax and argument details | Free |
How-to Guide
1. Enter the function from the Insert Function dialog
Entry path: Formulas tab → Insert Function
- Select the cell where you want to enter the formula.
- Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
- Search for MDURATION in the dialog box.
- Select the function and click OK.
- Enter the required arguments in the Function Arguments dialog.
- Click OK to finish inserting the function.
Success Criteria
- Interface result: The target cell now contains the MDURATION function.
- Next action available: You can continue editing arguments or copy the formula to other cells.
Tips While Using
- Common mistake: Extra spaces in the function name can affect search results.
- Environment note: An internet connection may be needed if you open online help links.
2. Type the formula directly in a cell
Entry path: Worksheet cell → Formula bar
- Select the cell where you want to enter the formula.
- Type
=MDURATION(...)directly in the cell or in the formula bar. - Press Enter to confirm.
- If you want to review argument guidance, type
=MDURATION(and then press F1 to open syntax help.
Success Criteria
- Interface result: The cell shows a calculation result, and the formula bar keeps the full formula.
- Next action available: You can fill the formula across cells or revise referenced arguments.
Tips While Using
- Common mistake: Using full-width commas can prevent the formula from calculating correctly.
- Environment note: Date and numeric arguments should stay in valid calculation formats.
3. Review the syntax and argument details
Entry path: Formulas tab → Insert Function
- Click Insert Function on the Formulas tab.
- Enter MDURATION in the search box.
- Select the function and review the syntax:
MDURATION(settlement, maturity, coupon, yield, frequency, [basis]). - Open the related help entry to read more details.
Success Criteria
- Interface result: You can see the function name, argument order, and syntax format.
- Next action available: You can return to the worksheet and enter the formula with the argument guidance.
Tips While Using
- Common mistake: Entering settlement or maturity as plain text instead of valid dates can cause errors.
- Environment note: The help display may vary slightly by interface version.