Results 1 to 15 of 15

Continually increasing the value of a cell, and implying the result on a column

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2008
    Posts
    22

    Continually increasing the value of a cell, and implying the result on a column

    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!
    Last edited by Jenkkipurkka; 06-19-2008 at 11:30 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1