SYD Function in Excel

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

What is SYD Function in Excel? 

The SLN Function in Excel is employed to return the sum of years, digits depreciation of an asset for a specified period. 


=SYD (cost, salvage, life, per) 


  • Cost– Assest’s cost at initial. (Required) 
  • Salvage– The value of the asset at the end of the description. (Required) 
  • Life– The total number of periods over which the asset is depreciated. (Required) 
  • Per– The period to calculate depreciation for. (Required) 


=SYD (A2, B3, C4, D5) 

=SYD (A3, A4, A5, 5) 

How to use SYD Function in Excel? 

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

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