ProductSolutionsTemplatesResources

SLN

Calculates the depreciation of an asset for one period using the straight-line method. Learn more

Video field
Financial

In Google Sheets, SLN is a financial function that calculates the straight-line depreciation of an asset over its useful life.

The parameters for the function are:

cost: The initial cost of the asset. salvage: The value of the asset at the end of its useful life. life: The number of periods (usually years) over which the asset will be depreciated. The function returns the amount of depreciation for each period using the straight-line method, which means that the depreciation expense is evenly distributed over the life of the asset.

SLN stands for "straight-line depreciation."

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!