Support Board
Date/Time: Fri, 27 Dec 2024 17:15:10 +0000
Post From: simple alert formula
[2015-10-26 00:54:48] |
Sawtooth - Posts: 4143 |
Maybe you want an alert when any of the three occur, while the others have already occurred. Try this: =OR( AND(ID3.SG2[-1]>ID3.SG1[-1],ID3.SG1>ID3.SG2,OR(ID1.SG1>100,ID1.SG1<-100),ID1.SG2<=2200), AND(ID3.SG1>ID3.SG2,OR(AND(ID1.SG1[-1]>0,ID1.SG1[-1]<100,ID1.SG1>100),AND(ID1.SG1[-1]<0,ID1.SG1[-1]>-100,ID1.SG1<-100),ID1.SG2<=2200), AND(ID3.SG1>ID3.SG2,OR(ID1.SG1>100,ID1.SG1<-100),ID1.SG2[-1]>2200,ID1.SG2<=2200)) The original formula is tripled, each with one crossover (the bolded). These are then combined with an OR to separate the individual crossovers. This is untested because I don't know the studies that are referenced. |