Closed Thread
Results 1 to 3 of 3

Depreciation

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Depreciation

    How to stop depreciation after its fully depreciation?
    Plz check attachement
    The useful life is 26 periiods
    First column is the truck id, i want to depreciate the tire price over 26 months
    The formula works but it continue to add depreciation cost even after 26 periods
    Attached Files Attached Files
    Last edited by Mahmoudelnemr; 05-14-2019 at 09:53 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,626

    Re: Depreciation

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. see our rules: https://www.excelforum.com/forum-rul...rum-rules.html


    I am, therefore, reporting this thread to be closed, but everybody is encouraged to continue in the second thread: https://www.excelforum.com/excel-for...reciation.html where you posted additional details
    Best Regards,

    Kaper

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Depreciation

    Thank you Kaper, thread closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Straight Line Depreciation for Long Term Model of Depreciation
    By fornight in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2017, 03:14 PM
  2. [SOLVED] Depreciation
    By domnicmifsud in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 06:40 AM
  3. [SOLVED] Formulas to show all previous depreciation combined, and also current depreciation.
    By Morisk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2012, 09:05 AM
  4. Depreciation
    By scallywag1000 in forum Excel General
    Replies: 5
    Last Post: 01-31-2011, 03:23 AM
  5. Depreciation formula
    By Cidona in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-24-2010, 11:15 AM
  6. Depreciation formula ?
    By leapinlizard in forum Excel General
    Replies: 3
    Last Post: 03-03-2007, 03:58 AM
  7. UDF for Depreciation
    By odysseyoflife in forum Excel General
    Replies: 0
    Last Post: 06-12-2006, 12:38 PM

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