|
PureBytes Links
Trading Reference Links
|
Actually, this will not work.
Forget about B1, and just use the following in Cell C1.
=if(A1>0,now(),C1)
Time will float until A1 becomes greater than 0.
Sorry for the confusion.
>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??????
>>
>>
>>
>
>
|