Both financial functions are available, and SLN can be used directly with help. Please refer to return the linear depreciation value of assets in a period. Syntax SLN cost is the original value of assets. Salvage value is the value of an asset at the end of depreciation (also called asset salvage value). Life is the depreciation period (sometimes called the useful life of an asset). Examples It may be easier to understand if you copy the examples into a blank worksheet. How to create a blank workbook or worksheet? Please select an example in the help topic. Do not select row or column headings. Select an example from the help. Press ctrl+C. In the worksheet, select cell A 1, and then press ctrl+v. To switch between viewing results and viewing formulas that return results, press CTRL+ ` (accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode. 1234AB data description 30,000 original value of assets 7,500 residual value of assets 10 service life formula description (result) =SLN(A2, A3, A4) annual depreciation value (2,250)