Results 1 to 3 of 3

Formulas to show all previous depreciation combined, and also current depreciation.

Threaded View

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    Grand Haven, MI
    MS-Off Ver
    Excel 2010
    Posts
    3

    Formulas to show all previous depreciation combined, and also current depreciation.

    What happens when you ask a production manager to help out with creating an accounting excel sheet?? You find a forum! Appreciate any help in advance!

    I need to create a formula that will calculate straight line depreciation. I need it to show a combined total of all previous years/months depreciation for an item, and also the current years depreciation. I have included a layout of how they would like it to look. I have come real close with some formulas I have found online, but not quite there yet.

    Thank you again,

    Mo
    Attached Files Attached Files
    Last edited by Morisk; 11-16-2012 at 03:11 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1