How to Use the ACCRINTM Function in WPS on Windows

Use ACCRINTM through 4 how-to topics that cover entering the function, filling in arguments with syntax prompts, using it in cross-sheet or nested formulas, and checking recalculated results; 4 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Enter the ACCRINTM function

Feature path: Formulas tab → formula bar

1. Open WPS Spreadsheet.
2. Select the cell where you want to enter the formula.
3. Type = in the formula bar or directly in the cell.
4. Continue by typing ACCRINTM( to start editing the function.

Success Criteria

• The current cell or formula bar is now in ACCRINTM editing mode.
• You can continue entering the function arguments.

Tips While Using

• The formula must start with =.
• If the formula becomes long, editing in the formula bar can make the full content easier to review.

2. Fill in arguments with syntax prompts

Feature path: Continue editing after ACCRINTM( appears

1. After typing ACCRINTM(, review the syntax prompt shown by the app.
2. Check the required arguments and example format in the prompt.
3. Enter the arguments in order.
4. Review the parentheses, commas, and argument order.
5. Press Enter to confirm.

Success Criteria

• The cell shows a calculation result, or the function entry is accepted.
• The argument structure in the formula matches the syntax prompt.

Tips While Using

• Common errors include unmatched parentheses, missing commas, and incorrect argument types or counts.
• Some versions may also support semicolons as separators, but commas remain a common format.

3. Use ACCRINTM in cross-sheet or nested formulas

Feature path: Target cell → formula bar

1. Select the cell where you want the result to appear.
2. Type =ACCRINTM( and enter the basic arguments.
3. Reference cells from other worksheets as needed.
4. Add other expressions or nested formulas in the arguments when your calculation requires them.
5. Check that the formula structure is complete, then press Enter.

Success Criteria

• The formula returns a result normally.
• The formula includes a cross-sheet reference or a nested calculation structure.

Tips While Using

• Complex formulas are easier to review in the formula bar.
• If the result looks incorrect, check each reference and argument format one by one.

4. Update data and review recalculated results

Feature path: Result cell after referenced data changes

1. Edit the data referenced by the ACCRINTM formula.
2. Check whether the result cell updates automatically.
3. If the result does not update in time, press F9 to trigger recalculation manually.
4. On some laptop keyboards, you may need to use Fn+F9.
5. Compare the updated result with the current source data.

Success Criteria

• The result recalculates after data changes, either automatically or after manual recalculation.
• The updated result matches the current referenced data.

Tips While Using

• If the result is incorrect, check whether referenced cells contain numbers stored as text.
• Also review whether the formula contains a circular reference.