How to Use

Use ACCRINTM through 3 how-to topics, including inserting it from the function dialog, typing it directly, and reviewing syntax and parameters; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Insert ACCRINTM from the Insert Function dialog

Entry path: Formulas tab → Insert Function, or the fx button in the formula bar

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for ACCRINTM in the Insert Function dialog.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog.
6. Click OK to finish inserting the function.

Success Criteria

• On-screen result: The target cell now contains the ACCRINTM function.
• What you can do next: You can continue editing parameters, confirm the result, or copy the formula to other cells.

Tips While Using

• Common mistake: Search with the exact uppercase function name ACCRINTM to avoid selecting a different function.
• Parameter entry: Fill in parameters in the order issue, settlement, rate, par, [basis] to reduce input errors.

2. Type the formula directly in a cell

Entry path: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =ACCRINTM(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review parameter guidance, type =ACCRINTM( and press F1 to view syntax help.

Success Criteria

• On-screen result: The cell shows the calculation result, and the full formula remains visible in the formula bar.
• What you can do next: You can drag the fill handle, copy the formula, or adjust parameters.

Tips While Using

• Common mistake: Use English commas to separate parameters. Full-width punctuation can cause formula errors.
• Input check: Make sure the formula starts with an equals sign and that parentheses are paired correctly.

3. Review the syntax and parameter details

Entry path: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter ACCRINTM in the search box.
3. Select the function and review the syntax ACCRINTM(issue, settlement, rate, par, [basis]).
4. Click the help link for the function to open more details.

Success Criteria

• On-screen result: You can see the function syntax and parameter names.
• What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

• Common mistake: Do not confuse parameter names such as settlement and maturity when comparing similar finance functions.
• Troubleshooting tip: If the result looks wrong, check the date values, rate, par value, and basis setting first.