Hello Gurus i am trying to develop a very dynamic Fixed Asset depreciation schedule but facing a slight formula or logic challenge and as usual seeking your expert advice. Basically what this current schedule does is assuming you want to depreciate your asset for say 5 years, starting from 2013 you will see information for only the five years ending 2017 so at the end of the 5th year, the asset would have been fully depreciated, assuming however in 2014 you acquired another asset and you expert to depreciate it for 5 years also, it means by the end of 2018 you should have depreciated the 2nd acquisition fully,
The Scenario in cell B9, i have entered the no of years for depreciation for the first asset purchased in 2013 and am using the formula IF($B$9<=COLUMN(A1),"",B11+1) in cell c11 to be able to cut off years after 2017 ( ie 5 years), The Problem however if i enter the new purchase of asset in cell B27, then i would have to enter the no of yrs for deprn for this asset in cell c9, then i expert this formula to be modified IF($B$9<=COLUMN(A1),"",B11+1) so that the cut off year will be in 2018, it has to be dynamic such that if i enter say a new purchase in csll D27 and i enter say a the no of yr for deprn for this asset in cell E9 the cut off year would be 2020 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Depreciation Schedule.xlsb
Description: Binary data
