How to Use Excel's SLN Function

The SLN function in Microsoft Excel is used to find the straight-line depreciation of any asset. In order to calculate this information, you will need to have cells that contain the cost, salvage and useful life of a particular asset. Follow the steps below to learn how to use this straight-forward function that will quickly calculate depreciation for you.

Instructions

Difficulty: Moderately Easy

Things You’ll Need:

• Microsoft Excel

1. Start Microsoft Excel, and open an existing file that contains data you would like to use to calculate the straight-line depreciation of an asset.
2. Select the cell you would like to enter the SLN function into and get a return back.
3. Plan to use the function syntax of SLN (cost, salvage, life) to determine the depreciation of the referred to asset. Determine in what cells the information on the cost, salvage and life reside and take note of the cell reference.
4. Type the formula to get the straight-line depreciation result. Assume you have the cost of the asset in cell B3, the salvage value in cell C3 and the years of useful life in cell D3. For this example, you would type in the formula of "=SLN(B3, C3, D3" (without the quotation marks).
5. Press the "Enter" key to enter the function into Excel. You should see the return appear immediately in the selected cell.

Tips & Warnings

• Instead of cell references, you can also input numbers directly into the function. This will give you a return of the value calculated from the function.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.