This how-to guide covers 3 operation topics for the PDURATION function, including inserting it from the function dialog, typing it directly, and checking syntax details before use.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert it from the Insert Function dialog | Free |
| 2 | 2. Type the formula directly in a cell | Free |
| 3 | 3. Check the syntax and parameter details | Free |
How-to Guide
1. Insert it from the Insert Function dialog
Entry: 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 PDURATION in the Insert Function dialog box.
- Select the function and click OK.
- Enter each parameter in the Function Arguments dialog box.
- Click OK to finish inserting the function.
Success Criteria
- The selected cell now contains the PDURATION function.
- A calculation result appears after the parameters are entered.
Tips While Using
- Enter the parameters in the order
rate, pv, fv.- Use numbers or valid cell references for the arguments.
2. Type the formula directly in a cell
Entry: Cell area → Formula bar
- Select the cell where you want to enter the formula.
- Type
=PDURATION(...)directly in the cell or in the formula bar. - Press Enter to confirm.
- If you want to review the parameter pattern, type
=PDURATION(and check the on-screen prompt.
Success Criteria
- The cell displays a calculation result.
- The full formula is visible in the formula bar.
Tips While Using
- Use English commas to separate parameters.
- If the result looks incorrect, check the cell format and referenced values.
3. Check the syntax and parameter details
Entry: Formulas tab → Insert Function
- Click Insert Function on the Formulas tab.
- Type PDURATION in the search box.
- Select the function and review the syntax:
PDURATION(rate, pv, fv). - Click the help link for the function to open more details.
Success Criteria
- The function syntax and parameter names are visible.
- You can continue filling in the formula with the correct argument order.
Tips While Using
- Do not switch the order of the parameters.
- An internet connection is needed when opening the help link.