Please see the example attached:
\1
In Column G (which calculates the ratio between the sum of column D and column A), I would like to provide a list of how the value in cell J4 is affecting the mentioned ratio. (Column C and column D are both dependent of J4).
For instance, now a J4-value of 70 results in a ratio of 0,232, which is written in column G. I would like this be calculated "continously" (my goal is to plot the result in a coordinate system), or at least with a regular interval. The result would then be like in the sheet attached below.
I'm grateful for any help!
Edit: I have problems with htmlMaker, I try to fix this a second message below.
Unless I manage to get the code working, feel free to ask if I haven't been clear enough!
Bookmarks