Formulas > =AMORLINC()
How To Use AMORLINC() Function in Google Sheets
Description
How To Actually Use AMORLINC() in Sheets
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Try AMORLINC yourself
In cells A1 to A6, input the cost, purchase date, first period end, salvage value, period, and rate of an asset. Use the AMORLINC formula in cell B1 to calculate the depreciation for the first period.
Hints (3)
-
Make sure to input the correct data types for each parameter.
-
The purchase date should be in a date format.
-
Check the order of parameters in the AMORLINC function.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the AMORLINC() formula:
Generate a AMORLINC() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses AMORLINC(). 2 free AI generations, no signup. Members get unlimited use.
Generate a AMORLINC() formula