SLN Function

The SLN function calculates the Straight Line Depreciation of an item, with the given values.


= SLN(Cost, Salvage, Life)
Whereas Cost - initial cost of the asset.
Salvage - value at the end of the depreciation or the Selling Price
Life - the number of periods over which the asset is depreciated.
SLN is calculated as the difference between Cost and Salvage divided by the life (no of years)

Video Tutorial:

Let us check if the given number is positive or negative, using the SIGN function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question