+ Reply to Thread
Results 1 to 2 of 2

Leave existing data in a cell alone

Hybrid View

  1. #1
    Running Out of Ideas
    Guest

    Leave existing data in a cell alone


    I am trying to figure out a way to calculate data in a cell if the date is
    current, or leave it alone (no operation) if it isn't. Basically I am using a
    table to calculate test execution data. It would look something like the
    following:

    A B
    1 96% 90% (data calculated on 3/1)

    1 95% 89% (data Claculated on 3/2 in the same cells as above)

    I then have another table that stores the data (manually right now) so that
    I can graph it daily as follows:

    A B C
    5 3/1 96% 90%
    6 3/2 95% 89%

    What I was trying to do in B5 was =if(A5=TODAY(),A1,IF(A5<TODAY(),leave the
    cell alone.

    I can't seem to figure out a way to do this.

    Help!!!

  2. #2
    Herbert Seidenberg
    Guest

    Re: Leave existing data in a cell alone

    This will require circular reference, an advanced feature.
    For ease of testing, this example uses 5 second intervals
    instead of whole days.
    Your data might look like this:
    Meas
    88
    When Monitor
    3/29/2006 16:44:00 89.00
    3/29/2006 16:44:05 90.00
    3/29/2006 16:44:10 91.00
    3/29/2006 16:44:15 92.00
    3/29/2006 16:44:20 92.00
    3/29/2006 16:44:25 93.00
    3/29/2006 16:44:30 94.00
    3/29/2006 16:44:35 95.00
    3/29/2006 16:44:40 96.00
    3/29/2006 16:44:45 97.00
    3/29/2006 16:44:50 98.00
    3/29/2006 16:44:55

    Name the cell <Meas> and the ranges <When>, <Monitor>.
    Set Iterate to 1
    Fill the <Monitor> column with this formula
    =IF(AND(NOW()>=When,NOW()<When R[1]),Meas,Monitor)
    It is written in R1C1 style.
    For <When>, select a time ahead when you might start a test.
    During the 5 second interval between 16:44:00 and 16:44:05
    you can enter data into <Meas> and it will appear in <Monitor>.
    At 16:44:05, this value will be locked into the first row of <Monitor>
    and the next 5 second interval will be ready to sample <Meas>.
    After everything works, revert to A1 and change the interval to one day.


+ Reply to Thread

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