SLN Function in Excel

In this post, let’s learn how the SLN Function works in excel, describe the formula syntax, and how you can use the SLN Function in your excel spreadsheet

What is SLN Function in Excel? 

The SLN Function in Excel is employed to return the straight line, depreciation of an asset for one period. 


=SLN (cost, salvage, life) 


  • Cost– Assest’s cost at initial. (Required) 
  • Salvage– The value of the asset at the end of the description. (Required) 
  • Life– The entire number of periods over which the asset is depreciated. (Required) 


=SLN (A2, A3, A4) 

=SLN (A2, B3, C4) 

How to use SLN Function in Excel? 

The following steps will explain the work of the SLN Function in Excel spreadsheet

  • First, prepare an excel spreadsheet with the specified details in it, or open an existing file. 
  • To perform the SLN Function you need the parameters described in the description. 
  • Enter those values in cells and enter the command SLN followed by the “=” operator within the parenthesis enter the parameters. 
How to use SLN Function in Excel?