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
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