==AMORLINC(cost, purchase, first, salvage, period, rate, [basis])
=AMORLINC(10000,date(2019,6,30),date(2019,12,31),1000,3,0.2,4
) This example returns the depreciation in period 3. This is because the cost argument is 10,000, the salvage argument is 1,000, the rate argument is 0.2, and the basis argument is 4.
=AMORLINC($C$5,$C$6,$C$7,$C$8,E7,$C$9,$C$10)
This example returns the depreciation in period 5. This is because the cost argument is $10,000, the second argument is date(2019,6,30), the third argument is date(2019,12,31), the rate is 20%, and the salvage value is $1000.
The AMORLINC function is used to calculate the depreciation of an asset over a given number of accounting periods. It takes six arguments and accounts for prorated depreciation when an asset is purchased within an accounting period.