How to Use the ACCRINTM Function in WPS on Windows

Last updated:July 20, 2026

Use ACCRINTM through 4 worksheet tasks, all available without membership; choose a topic from the How-to Index and follow the steps to enter the function, complete arguments, and verify the result.

How-to Index

No.TopicMembership Requirement
11. Enter the ACCRINTM functionFree
22. Fill in arguments with syntax guidanceFree
33. Use references and nested formulasFree
44. Check results and recalculateFree

How-to Guide

1. Enter the ACCRINTM function

Entry path: Formulas tab → formula bar

  1. Open WPS Spreadsheet and go to the target worksheet.
  2. Select the cell where you want the result to appear.
  3. Type = to begin the formula.
  4. Type ACCRINTM(.

Success Criteria

  • Interface result: The cell enters formula editing mode.
  • Next action available: You can continue entering the function arguments.

Tips While Using

  • Common mistake: If you do not type = first, the content may be treated as plain text.

2. Fill in arguments with syntax guidance

Entry path: Select the result cell → formula bar

  1. After typing ACCRINTM(, review the syntax prompt that appears.
  2. Enter each required argument in order.
  3. Separate arguments with commas.
  4. Make sure the closing parenthesis is complete.
  5. Press Enter to calculate.

Success Criteria

  • Interface result: The cell displays a calculation result.
  • Next action available: You can select the result cell and review the full formula.

Tips While Using

  • Common mistake: Missing arguments, separators, or parentheses can cause an error result.

3. Use references and nested formulas

Entry path: formula bar

  1. In each argument position, select worksheet cells or ranges directly as references.
  2. If you need values from another worksheet, switch sheets and select the target cell.
  3. If you need a combined calculation, nest another function inside an argument.
  4. Press Enter to return the result.

Success Criteria

  • Interface result: The formula shows worksheet or cell references.
  • Next action available: You can change referenced values and observe updated results.

Tips While Using

  • Common mistake: Text-formatted numbers in referenced cells can affect the calculation result.

4. Check results and recalculate

Entry path: result cell → formula bar / press Enter after editing

  1. Select the cell that already contains the result.
  2. Review the function name, argument order, and referenced ranges in the formula bar.
  3. Change the source data and confirm whether the worksheet result updates.
  4. If needed, double-click the cell or edit in the formula bar, then press Enter again.

Success Criteria

  • Interface result: The result stays aligned with the updated arguments.
  • Next action available: You can copy the formula or fill it down to other cells.

Tips While Using

  • Common mistake: Before reviewing the result, confirm that dates, rates, and other inputs use the expected format.