How to Use

Use AMORLINC with 3 how-to topics, including inserting it from the Insert Function dialog box, typing the formula directly in a cell, and reviewing syntax and parameter details before use.

How-to Index

How-to Guide

1. Insert the function from the Insert Function dialog box

Entry point: Formulas tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for AMORLINC in the dialog box.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog box.
6. Click OK to insert the formula.

Success Criteria

• The selected cell now contains the AMORLINC function.
• After the arguments are entered, the cell returns a calculation result.

Tips While Using

• Separate arguments with English commas.
• Make sure date and numeric arguments use the correct data types.

2. Type the formula directly in a cell

Entry point: Worksheet cell → Formula bar

1. Select the target cell.
2. Type =AMORLINC(...) directly in the cell or the formula bar.
3. Press Enter to confirm.
4. If you want to review the function prompt, type =AMORLINC( and then press F1.

Success Criteria

• The cell shows a result or remains ready for further formula editing.
• The full AMORLINC formula is visible in the formula bar.

Tips While Using

• Before filling the formula across multiple cells, check whether relative and absolute references are set correctly.
• If the result looks incorrect, review the argument order and the cell formats first.

3. Review syntax and parameter details

Entry point: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Search for AMORLINC.
3. Review the syntax: AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis]).
4. Open the related help entry if you need more detailed parameter guidance.

Success Criteria

• You can see the full function syntax.
• You can distinguish required arguments from the optional [basis] argument.

Tips While Using

• Use valid date values for date arguments.
• Test the formula with a small sample dataset before applying it to a full worksheet.