How to Use the AMORLINC Function in WPS on Windows

Last updated:July 20, 2026

Use the AMORLINC function with 4 how-to topics, including 4 free topics and 0 membership-related items; start from the How-to Index and follow the steps to enter, check, and update the formula.

How-to Index

No.TopicMembership Requirement
11. Enter the AMORLINC functionFree
22. Fill in parameters with syntax guidanceFree
33. Use cell references or cross-sheet references in the calculationFree
44. Check errors and update the resultFree

How-to Guide

1. Enter the AMORLINC function

Entry point: the target worksheet cell or the formula bar in WPS Spreadsheet

  1. Open WPS Spreadsheet and go to the worksheet where you want to calculate depreciation.
  2. Click the target cell, or click the formula bar first.
  3. Type an equals sign = to start the formula.
  4. Continue with AMORLINC(.

Success Criteria

  • Interface result: =AMORLINC( is visible 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 skip the equals sign, the content may be treated as plain text.
  • Environment note: make sure you are editing a writable worksheet cell.

2. Fill in parameters with syntax guidance

Entry point: the syntax guidance area while the function is being entered

  1. After typing AMORLINC(, check the syntax guidance shown in the interface.
  2. Enter the required parameters in order.
  3. Separate parameters with the correct delimiter.
  4. Type the closing parenthesis ) to complete the formula structure.

Success Criteria

  • Interface result: the formula structure is complete and the parameter positions are clear.
  • Next action available: you can press Enter and review the result.

Tips While Using

  • Common mistake: unmatched parentheses or incomplete parameters can prevent the formula from calculating correctly.
  • Environment note: using cell references for parameters can make later edits easier.

3. Use cell references or cross-sheet references in the calculation

Entry point: the formula cell where AMORLINC is being edited

  1. In a parameter position of AMORLINC, click the cell you want to reference.
  2. If you need a cross-sheet reference, switch to the target worksheet and select the target cell.
  3. Check whether the reference address has been inserted correctly into the formula.
  4. Press Enter to confirm the calculation.

Success Criteria

  • Interface result: the formula includes a cell reference or worksheet reference.
  • Next action available: you can change the referenced value and observe the updated result.

Tips While Using

  • Common mistake: referencing the wrong cell directly affects the depreciation result.
  • Environment note: before using cross-sheet references, confirm that the related worksheet still exists and contains complete data.

4. Check errors and update the result

Entry point: the result cell that already contains the formula

  1. If the result shows an error, first check whether the function name is spelled AMORLINC.
  2. Then check the parentheses, parameter order, and delimiters.
  3. Review whether the referenced cells contain data types suitable for calculation.
  4. After changing parameters or referenced values, check whether the result updates.

Success Criteria

  • Interface result: the error is cleared or the result cell returns a valid value.
  • Next action available: you can continue copying the formula or adjusting parameters.

Tips While Using

  • Common mistake: text-formatted numbers, missing delimiters, or circular references can affect the result.
  • Environment note: when referenced data changes, review whether the updated result matches your expectation.