Returns a number with the sum-of-years' digits depreciation of an asset for a specified period.

  • Returned Output: Numeric
  • Library: MDX \ VBA \ Financial
  • Version: 2018.00.000
  • Compatibility: Microsoft MDX Engines only


SYD( <Cost> , <Salvage> , <Life> , <period> )

Further Help on Syntax and Examples
  • For more details on using the VBA library in MDX please click here.
  • For more details on the syntax of the VBA function please click here