|
PureBytes Links
Trading Reference Links
|
Gerald,
Sounds like you're doing some interesting research. Perhaps you could let us
know what you're testing.
My solution to this is as follows:
If A1 has the value that is >0 or not
and if B1 has the time function now()
and C1 contains your formula, I would write it like:
=if(A1>0,B1,C1)
Note that this creates a circular logic in your spreadsheet. I have
compensated for this by changing my Tools, Options, Calculation, Iteration
maximum to 1 so it doesn't iterate all day long.
Hope this helps. There are some other problems that may arise if you get the
#N/A in your formula, but for now, going to that cell and pressing F2, then
enter will resolve it.
Patrick White
-----Original Message-----
From: Gerald Marisch <gm@xxxxxxxxxxxxx>
To: Omega list <omega-list@xxxxxxxxxx>
Date: Friday, February 19, 1999 11:03 AM
Subject: EXCEL w/ TS
>I'm using an Excel Spreadsheet with TS.
>
>For one cell, I would like the time to be automatically entered when
another
>cell (the "Fill Cell") has a value >0.
>Further, I would like to "lock in" this time.
>
>The IF conditional and "NOW()" works, but the time does not stop.
>
>Anyone have an idea??????
>
>
>
|