How to Use the AMORLINC Function in WPS on Windows

This guide includes 4 how-to topics, all available without membership; choose a topic from the How-to Index and follow the entry path and steps to complete the task.

How-to Index

How-to Guide

1. Enter the AMORLINC function

Entry path: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want the result to appear.
2. Type = to begin the formula.
3. Continue by typing AMORLINC(.
4. Check the function prompt that appears before entering parameters.

Success Criteria

• On-screen result: =AMORLINC( appears in the cell or formula bar.
• Next action available: You can continue entering parameters 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 parameters with syntax guidance

Entry path: Select the target cell → formula bar

1. After typing AMORLINC(, review the parameter guidance and example shown by WPS.
2. Enter the required parameters in the displayed order.
3. Separate parameters with commas.
4. Type the closing parenthesis and press Enter.

Success Criteria

• On-screen result: The cell shows a calculation result instead of staying in edit mode.
• Next action available: When you select the cell again, the full formula is visible in the formula bar.

Tips While Using

• Common mistake: Missing parentheses, incomplete parameters, or missing separators can cause an error.
• Environment note: Parameter values need to match the required types and order.

3. Use cross-sheet references in the formula

Entry path: Formula bar → select a cell in another worksheet

1. In the target cell, type =AMORLINC( and begin entering parameters.
2. When one parameter should come from another worksheet, switch to that worksheet.
3. Select the cell you want to reference so its address is inserted into the formula.
4. Return to the current worksheet, complete the remaining parameters, and press Enter.

Success Criteria

• On-screen result: The formula includes a reference to another worksheet.
• Next action available: If the referenced cell changes, the result can recalculate.

Tips While Using

• Common mistake: Referencing the wrong worksheet or wrong cell affects the result.
• Environment note: The referenced worksheet needs to remain in the current workbook.

4. Update results automatically when data changes

Entry path: Edit a cell used by the formula

1. Find the parameter cells referenced by the AMORLINC formula.
2. Change one or more parameter values.
3. Press Enter to confirm the edit.
4. Return to the result cell and review the updated calculation.

Success Criteria

• On-screen result: The value in the result cell updates after the source data changes.
• Next action available: You can continue adjusting parameters and reviewing new results.

Tips While Using

• Common mistake: Entering numbers as text may affect the result.
• Environment note: If the workbook uses a special calculation setting, check whether the result has refreshed.