Login Page - Create Account

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.