How to Use the ACCRINT Function in WPS on Windows

This section includes 4 how-to topics for using ACCRINT in WPS Spreadsheet on Windows; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Enter the ACCRINT function

Entry path: Formulas tab → formula bar or target cell

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to start the formula.
3. Continue by typing ACCRINT(.
4. Review the syntax prompt to confirm the function name and argument order.

Success Criteria

• Interface result: The cell enters formula editing mode and shows ACCRINT(.
• Next action available: You can continue entering arguments or selecting referenced cells.

Tips While Using

• Common mistake: If you do not start with =, the content may be treated as plain text.
• Environment note: This action must be done in an editable spreadsheet cell.

2. Fill in ACCRINT arguments

Entry path: Target cell → formula editing mode

1. Enter the issue date, first interest date, and settlement date in order.
2. Enter the rate, par value, and payment frequency.
3. Add optional arguments if needed.
4. Type the closing parenthesis and press Enter.

Success Criteria

• Interface result: The cell returns a calculated result instead of plain function text.
• Next action available: You can select the result cell and review the full formula.

Tips While Using

• Common mistake: Missing parentheses, incomplete arguments, or incorrect separators can cause an error.
• Environment note: Dates and numbers should use valid cell formats.

3. Reference cells or cross-sheet data

Entry path: Formula bar → select argument cells

1. While entering the formula, click the cell that contains a date or numeric value.
2. Continue selecting other cells in the required argument order.
3. If you need a cross-sheet reference, switch to the target worksheet and select the cell.
4. Press Enter after the formula is complete.

Success Criteria

• Interface result: The formula shows cell references or worksheet references.
• Next action available: You can change source cells and observe the updated result.

Tips While Using

• Common mistake: If the argument order and referenced cells do not match, the result may be affected.
• Environment note: Cross-sheet references require valid worksheets and valid target cells.

4. Check results and recalculation

Entry path: Result cell → edit referenced data

1. Record the current ACCRINT result first.
2. Change a referenced date or numeric cell in the formula inputs.
3. Check whether the result cell updates automatically.
4. If the result looks incorrect, return to the formula bar and review the argument format and order.

Success Criteria

• Interface result: The result cell updates when referenced data changes.
• Next action available: You can continue adjusting arguments and compare results.

Tips While Using

• Common mistake: Entering dates as plain text may cause incorrect results.
• Environment note: Recalculation depends on a valid formula and recognizable data formats.