Excel formula for calculating depreciation

  old fogey 10:44 22 Jun 2005

Can anyone help with a problem Ive been given and that is I want to calculate the depreciation of equipment (office machines) and I dont know the formula to use in excel.

  Rand Al Thor 11:12 22 Jun 2005

Type Depreciation into the help. There are a number of functions there.

  old fogey 11:20 22 Jun 2005

Rand Al Thor
Thanks I have looked in the excel help but could not find the formula

  Durko 11:43 22 Jun 2005

Have a look at this site might be of some help.

click here


  old fogey 11:55 22 Jun 2005

Thanks thats just what I was looking for

  VoG II 11:58 22 Jun 2005

The FirstYearMonth is the month in which the item was purchased during the first financial year. This is an optional value, if it not used the function will assume 12 as the value.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

Best Keyboards for Designers & Artists

What to ask Siri on the HomePod

Meilleurs VPN (2018)