Hi there and welcome
I can help you with this.
Provide me the sheet via the below instructions and tell me what the formula needs to do please.
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
You see the price now show up on the screen, so accept it please and we can do this.
May be a payment issue, but send me the file please and we can continue for now.
ok, and the File ID please?
ok, I need the file ID to download it please
I still need to know though what you want done as you have only said Match Data.
ok.. you need to be a little more specific please.
what exactly do you mean by formulas that will support data?
ok sorry but your only saying build formulas with no explanation of what you want the formulas to do.
Are you willing to explain to me what you actually want the formulas to do?
no, you cannot just figure out from the numbers, you need to tell me the rules for the actual formula...
ok, looking at it now
you say line 7 divided by 5 equals line 8but line 8 = 44.3 and it should be 70 if its divided by 5 right?
also the dame for the following line 9 divided by 5 equals line 10
you said line 5 was 7.9% and 350/790 does not give the results....
Can you please check carefully and tell me please the calculations that should occur.
ok, done the rules you request except "49 column G is difference between line 39 column G and line 42G let me know if this can be done: as there is not line 49
You can get the file from www.wiksiend.com under file id 771160
Let me know the results
its working for me.
try this link
no they match the rules you sent me, I have to follow the rules you gave, its the only way this will work, and I suspect you had some mistakes in some of them as line 49 did not even exist...
ok, I understand all except
line 14 should be 5%
What do you man as 14 is percentages
sorry not following
Line 14 is row 13 divided by row 5
Line 13 already goes up 5% each year
How exactly do you want line 14 calculated as just saying 5% does not make sense sorry
ok, its 17% as thats the result of the calculation but I just typed in 5% instead if you require this.
I have uploaded it under file id 177458
it does, it adds 7.9% to the previous year
C11 = 231.25 which is 7.9% more then 214.32
Did you get my latest version?
file id 177458 from www.wikisend.com
ok it is line 32 minus 33,34,35,36 but you mean
33+,34+,35+,36 - 32
line 40 is line 39 divided by 9
132.36/474.93 = -27.87 but I believe you want it as a positive? So converted it to this
File ID 521968
yes then its how I had it which is a positive
The formula is 33+34+35+36 - 32
Manually do it with a calculator and you see it is correct.
ok I see you have not taken into account the + and - when explaining the rule as this impacts the calculations. Technically the calculations thats being done is not correct as its a minus number to a + but I added this into it
File ID 253730
Please check it
39c = 38b + 38c
as A is the text
ok done, File ID 192630
was there anything else with the file you needed done?
ok, you said line 23 goes up 1.6% per year, but I changed it.
Also added the formula for line 45
It is C38+D38
The latest version is ID 632884, please make sure you are checking that
yes the original is C38 56.21 + D38 67.78
Which equals 121.33
Yours says 173.85 for the addition of the two same figures.
Please try to realize your sheet has miscalculation, the formulas is correct
those figures 121.33 plus the new FCF of 65.92 dont exist anywhere on the sheet
I have put a lot of effort into trying to make sense of what you want done, even when you keep changing this, but I would really appreciate if you could put some time aside and carefully think through how the calculations should work and tell me. I have done this with you and would appreciate you doing the same as it makes no sense to just keep doing things and then re-doing them because what your telling me is not correct.
When you say I need formula to be $173.85 because we are adding 121.33 plus the new FCF of 65.92. yes none of this exists on the sheet, then please explain EXACTLY how you get this. Else how am I meant to do the formula? I want to get this done for you but I really need some effort on your side as well please Ben