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

Formula is not giving correct answer

I am trying to make a Dynamic formula from manual formula but my result is different.

can someone please help me in this regards.

Both formulas are available in sheet.
 

Attachments

  • Book1.xlsx
    29.5 KB · Views: 8
In the I5 formula uou haven't subtracted 1 & multiplied by 100 which you have done with the H5 formula
 
That is the answer by putting that values -1)*100 in last and after red -1)*100 but still result is not same.
 

Attachments

  • 1607552112899.png
    1607552112899.png
    11.9 KB · Views: 6
Last edited:
LearnExcel&VBA
How would those You 'date' match with something?
Your 1st 'green' result (0.84... ) should use seven cells and other 12 cells range with Your correct formula.
... and 2nd 'orange' result should use dates as with below snapshot... hmm?
=> Your formula gives correct results ... but ... it won't work within same ranges. <=
Screenshot 2020-12-10 at 11.54.04.png
 

Attachments

  • Screenshot 2020-12-10 at 11.54.04.png
    Screenshot 2020-12-10 at 11.54.04.png
    78.9 KB · Views: 0
How would those You 'date' match with something?
Your 1st 'green' result (0.84... ) should use seven cells and other 12 cells range with Your correct formula.

Sir, if date will start from 1-1-2020 then 0.84 will match 12 cell and now it starts from 1-7-2020 that's why it counted 7 cells.

I just want to make it dynamic to drag it down and accurate result should appear.
I was doing it manual whenever the date goes change.


... and 2nd 'orange' result should use dates as with below snapshot... hmm?

Yes it will match the result from Feb to Jan then again Feb to Jan. (That is our calculation method.)

=> Your formula gives correct results ... but ... it won't work within same ranges. <=

Sir then please share solution if it does not work
 
Back
Top