How to Use the AMORDEGRC Function in WPS on Windows

Last updated:July 20, 2026

Use AMORDEGRC through 4 how-to topics, all available without membership; start from the How-to Index to enter the function, fill in arguments, extend references, and update results.

How-to Index

No.TopicMembership Requirement
11. Enter the AMORDEGRC functionFree
22. Fill in arguments and complete the calculationFree
33. Use cross-sheet references in the formulaFree
44. Update the result after data changesFree

How-to Guide

1. Enter the AMORDEGRC function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want the result to appear.
  2. Type = to start a formula.
  3. Continue with AMORDEGRC(.
  4. Check the function guidance that appears and confirm the function name and argument structure.

Success Criteria

  • On-screen result: The cell enters formula editing mode and shows guidance related to AMORDEGRC.
  • What you can do next: You can continue entering arguments and complete the formula.

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 spreadsheet cell.

2. Fill in arguments and complete the calculation

Entry point: Select the target cell → formula bar

  1. After AMORDEGRC(, enter the required arguments in order.
  2. Separate arguments with commas and keep the parentheses matched.
  3. Check that the argument types and count match the function requirements.
  4. Press Enter to confirm the formula.

Success Criteria

  • On-screen result: The cell shows a calculation result instead of a formula error.
  • What you can do next: You can copy, fill, or reference the result cell.

Tips While Using

  • Common mistake: Unmatched parentheses, missing arguments, or incorrect separators can cause formula errors.
  • Environment note: The argument values need to match the function requirements.

3. Use cross-sheet references in the formula

Entry point: Formula bar → reference a cell in another worksheet

  1. In the target cell, type =AMORDEGRC( and begin entering arguments.
  2. Switch to another worksheet when you need to reference source data.
  3. Click the needed cell to insert its reference into the current formula.
  4. Return to the current worksheet, complete the remaining arguments, and confirm the formula.

Success Criteria

  • On-screen result: The formula includes a reference to another worksheet.
  • What you can do next: You can change the referenced cell and observe the updated result.

Tips While Using

  • Common mistake: Switching worksheets and forgetting to complete the remaining arguments.
  • Environment note: The referenced worksheet must be accessible in the current workbook.

4. Update the result after data changes

Entry point: Edit the cells used by the formula

  1. Find the argument cells referenced by the AMORDEGRC formula.
  2. Change one or more source values.
  3. Check whether the result cell updates automatically.
  4. If needed, select the formula cell again to review the current result state.

Success Criteria

  • On-screen result: The result cell updates when the source data changes.
  • What you can do next: You can continue adjusting arguments and compare different results.

Tips While Using

  • Common mistake: Entering numbers as text can affect the calculation result.
  • Environment note: If the workbook uses a special calculation setting, refresh behavior may differ.