When using AMORLINC, the most common questions fall into 3 areas: argument errors, unexpected results, and filling formulas across cells.
FAQ
What should I do if AMORLINC returns a #VALUE! error?
- Check whether each argument uses the correct data type, especially dates and numbers.
- Remove extra spaces or hidden characters from referenced cells if needed.
- Re-enter the formula after cleaning the source values.
Why does the AMORLINC result look different from what I expected?
- Check whether the referenced cells and argument order are correct.
- Confirm that the related cells are formatted as numbers or dates instead of text.
- Review the formula step by step with spreadsheet checking tools if needed.
How can I use AMORLINC in multiple cells?
- Enter the full formula in the first target cell.
- Drag the fill handle or copy and paste the formula to the target range.
- Review relative and absolute references, and add
$where needed.
Glossary
| Term | Definition |
|---|---|
| AMORLINC | A financial function that returns the depreciation for each accounting period. |
| salvage | The residual value of an asset at the end of its useful life. |
| basis | A date-count basis argument used to control how dates are handled in the depreciation calculation. |