How to Use the ACCRINT Function in WPS on Windows

Use ACCRINT with 4 how-to topics, including entering the function, filling in arguments, using cell references, and checking errors and recalculation; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Enter the ACCRINT function

Entry path: Formulas tab → formula bar

1. Open WPS Spreadsheets and select the cell where you want to show the result.
2. Type = in the formula bar or directly in the cell.
3. Continue by typing ACCRINT(.
4. Check whether the function syntax prompt and argument hints appear.

Success Criteria

• On-screen result: The cell enters formula editing mode and shows =ACCRINT(.
• What you can do next: You can continue entering arguments or reference other cells.

Tips While Using

• Common mistake: If you do not start with =, the content may be treated as plain text.
• Environment note: You need to work in an editable worksheet.

2. Fill in the function arguments

Entry path: A cell or formula bar that already contains =ACCRINT(

1. Enter date arguments such as the issue date, first interest date, and settlement date in order.
2. Enter numeric arguments such as the rate, par value, and payment frequency.
3. Add the day-count basis or other optional arguments when needed.
4. Check the parentheses, separators, and argument order, then press Enter.

Success Criteria

• On-screen result: The cell returns a calculated result or keeps the formula ready for further editing.
• What you can do next: You can double-click the cell to edit the arguments again.

Tips While Using

• Common mistake: Mismatched parentheses, incorrect argument order, or missing separators can cause formula errors.
• Environment note: Date and number formats need to match worksheet calculation requirements.

3. Use cell references to complete the calculation

Entry path: Formula bar or target result cell

1. Put dates, rate, par value, and other inputs into worksheet cells first.
2. In the result cell, type =ACCRINT(.
3. Click the corresponding input cells in order to insert cell references as arguments.
4. Press Enter to complete the calculation, then copy the formula to other rows or columns if needed.

Success Criteria

• On-screen result: The formula shows cell references and the result cell returns a calculated value.
• What you can do next: When referenced cells change, the result updates accordingly.

Tips While Using

• Common mistake: Referencing text-formatted numbers or invalid dates can produce unexpected results.
• Environment note: For cross-sheet references, confirm that the worksheet name and cell positions are correct.

4. Check errors and trigger recalculation

Entry path: Result cell or formula bar

1. If the result shows an error, first check whether the formula starts with =.
2. Review the parentheses, commas, and number of arguments.
3. Check whether the referenced cells contain valid dates, numbers, and frequency values.
4. After correcting the data, see whether the result updates automatically; if needed, press F9 to recalculate.

Success Criteria

• On-screen result: The error indication disappears and the cell shows an updated calculation result.
• What you can do next: You can continue copying, editing, or nesting the formula.

Tips While Using

• Common mistake: Text-formatted numbers, circular references, or invalid dates can affect the result.
• Environment note: The manual recalculation shortcut depends on your current system and keyboard settings.