Learn How to Use Microsoft Excel SLN Function

Microsoft Excel SLN Function

The main purpose of the Microsoft Excel SLN function is to get the depreciation at the straight line. That implies, with the help of the SLN function you can able to return the depreciation of an asset for one period, calculated with a straight-line method. It should be noted that the calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated. So, with the help of the SLN function, you can able to get the depreciation at the straight line.

Return Value of SLN Function

The return value will be the depreciation in the given period. 

Syntax of SLN Function

=SLN(cost, salvage, life)

Where the arguments:

• cost: This is the initial cost of the asset.
• salvage: This is the asset value at the end of depreciation.
• life: This is the period over which the asset is depreciated.

How to Use Microsoft Excel SLN Function?

So we know that Microsoft Excel SLN function you can able to get the depreciation at the straight line. That implies, with the help of the SLN function you can able to return the depreciation of an asset for one period, calculated with a straight-line method. It should be noted that the calculated depreciation is based on initial asset cost, salvage value, and the number of periods over which the asset is depreciated. So, with the help of the SLN function, you can able to get the depreciation at the straight line.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel