ACCRINT in WPS on Windows FAQ

Last updated:July 20, 2026

These FAQs cover 3 common question types about ACCRINT in WPS on Windows: input errors, argument understanding, and incorrect results.

FAQ

What should I do if the ACCRINT function shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses are complete and the separators are correct.
  3. Check whether the date, rate, par value, and frequency arguments are complete.
  4. If needed, re-enter =ACCRINT( and follow the syntax prompt step by step.

How can I view the ACCRINT argument instructions in WPS Spreadsheet?

  1. Select the target cell and type =ACCRINT(.
  2. Review the syntax prompt shown in the editing area.
  3. Enter the arguments in order to avoid skipping or missing items.
  4. If you want to verify the setup, insert the arguments through cell references one by one.

What should I check if the ACCRINT result looks incorrect?

  1. Check whether the dates use a valid date format instead of plain text.
  2. Check whether the argument order matches the function requirements.
  3. Check whether the referenced cells contain the correct rate, par value, and frequency values.
  4. After changing source data, review whether the result updates again.

Glossary

TermDefinition
ACCRINTA financial function used to calculate the accrued interest of a security that pays periodic interest.
Settlement dateThe date when the security is delivered to the buyer, and a key input in accrued interest calculations.
Payment frequencyThe number of interest payments per year, commonly 1, 2, or 4.