Problem with IF statemet

[imajik]

I have written an Excel spreadsheet to fire off bets in running on horse races. The main statement that generates the code sent to Bet Angel is in the form of an IF statement eg:

=IF($H3>$L3,"BACK STOP:5","")

(this is not my actual code but a simplifed example)

Now, when in running and the value in cell H3 becomes higher than the value in cell L3 the correct statement

"BACK STOP:5"

is entered in my cell. The problem is that it is possible that later in the race the values in H3 and L3 could change making the IF statement fail and removing the statement. What I want to happen is that when "BACK STOP:5" is entered into my cell it remains there until the event is over. Please could someone advise how I could do this?

Thanks for any help....

[beepbeep20]

If the conditions are met the bet is fired, once it's fired it doesn't matter to Betfair or Betangel whether the bet text still appears in the spreadsheet.

Or do you want to record the text of these bets for your own records/purposes ?

If so you could use VBA to detect when Excel says "Placing" and delete the formula replacing it with only the actual result. In you example replacing =IF(...) with "BACK STOP: 5".