Help with Function in Excel Pleeeeez

[Morpheus2004]

Hi Folks,

I want to do some analysis of the price movements within the race build up and need the following:

I will be running BA and have say Workbook1 logging the prices.....

To clarify exactly what I am looking for:
I want the formula below in 'workable' Excel format

A1="" This is where I wish to have a Message showing when a condition has been met.
A2="1" A default value for the spreadsheet
D1=(BACK PRICE 1)

"IF D1>A2 THEN PRINT "YES" IN A1 - Now I can write a conditional formula with =IF(D1>A1 ...... but the problem is that the formula is running all the time and I wish it to stop once the condition has been met! Otherwise, when the condition is met, it will show "YES" but then the moment the condition is no longer TRUE, it will then show "FALSE" and when I then view the sheet after the race, I cannot tell if the condition was ever met
I know how to run a formula/condition ONCE but not to have it run continually UNTIL a condition is met?????



Thanx in advance for any help

[The Gambling Monkey]

Hello,

I don't know how you'd do that in an excel formula but I do something similar using VBA.

Code: Select all

Option Explicit

Public RunWhen As Double
Public Const cRunIntervalSeconds = 15
Public Const cRunWhat = "CopyData"

Sub StartTimer()    'Chip Pearson

    RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
    Application.OnTime earliesttime:=RunWhen, procedure:=cRunWhat, schedule:=True
   
End Sub

Sub StopTimer() 'Chip Pearson

    On Error Resume Next
    Application.OnTime earliesttime:=RunWhen, procedure:=cRunWhat, schedule:=False

End Sub


Sub CopyData()
   If Range("A1").Value = "YES" Then Range("A1").Value = "YES"
End Sub


I don't know how much VBA you know, so any questions just ask, there are a lot of knowledgeable people on this forum.

Scott