Year to Date Depreciation

**omletto** · 06-07-2013, 10:51 AM

Could anyone help me with a formula to go into the Year to date depreciation Column?

I need it to stop when the asset is fully depreciated but still show the right number for year to date.

Any help would be appreciated.

R's

Om

**djauncey** · 06-07-2013, 12:18 PM

Can you attach an excel spreadsheet rather than a zipped folder?

Nothing personal, but I don't know what's inside it.

**jaslake** · 06-07-2013, 04:54 PM

Hi omletto

Try this formula in Cell Q10 and drag down

Please Login or Register  to view this content.

Also, change the formula in Cell P10 to this and drag down

Please Login or Register  to view this content.

You'll find a one(1) month difference in your Year To Date Depreciation...simply because I don't understand, having a months remaining life and having no depreciation...that's minor...if this formula works for you, we can fix it.

**omletto** · 06-08-2013, 06:29 AM

Thank you jaslake this looks to work. I'll test it thoroughly in work Monday. I kept getting lost, its quite a long formula.

Sorry djauncey, I thought you had to compress file. Will repost spreadsheet Monday.

Thanks again.

Om.