• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Table formula and date formula - Finance Depreciation

learnexcel365

New Member
Hi All -

Attached is the file I am having trouble with. I have similar information as China tab in multiple tabs and I am successfully able to combine it by using power query. But I realized for power query, I have to convert the data to table and when I do that my depreciation formula on the right side does not work. I have attached the "table" tab where my formulas are messed up when I convert data to table (Select data> insert>table)I have both tabs with exactly same formula. What is going on with the formula when converted to table?

Is there a more efficient way to combine data than using power query?

Also, I am having issue with line 56 in China tab. I do not want the formula to calculate any depreciation if my lease already expires(column J). My formula does not seem to be working and is calculating depreciation if after lease is expired and the depreciation is much higher than cash flow which is incorrect.

I would really appreciate some help
 

Attachments

  • Excel question 1.xlsx
    74.4 KB · Views: 10
Back
Top