Preserve previous data when Value_if_False

[ddawson7]

Good Morning Everyone:

I'm Dave Dawson (ddawson7) and this is my first day with your forum.

I need some advice on how to script "do nothing" if "Value_if_False".
I don't mean to text in "do nothing" I simple want excel to do nothing further, including don't replace last update with a zero or a blank cell.
I have created an excel spreadsheet using QLink to import my live stock market data which works fine, however
I want certain rows to stop updating upon a certain time frame or numerical value.
Right now I have =IF($C$21=B23,$D$21,"")
If I leave empty "", the cell goes blank when Value_if_False.
If I leave out the blank "", Excel provides a zero when Value_if_False.

My data comes into D21, continously updating.
My B column contains the minute index (ie: minute 1, minute 2 and so on)
So at 9:30 am, the market opens, that's minute 1, I want the data to update in row one (which I can get it to do correctly now)
until 9:31 which is minute 2. At this point I want the data to update row 2 (which I can also get it to do correctly now).
The problem is once Minute two arrives, I get a Value_if_False in row one thus replacing the data in row one with either blank cells or zero's.
How can I prevent excel from replacing the data in row 1 upon the arrival of minute 2.
I simple want the last piece of data received in row one to stay there when row 2 begins updateing.

Thanks,

Dave

[Cutter]

Hello ddawson7, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Original thread here: http://www.excelforum.com/excel-gene..._if_false.html

Thread Closed.