Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 08:23:52 +0000

How to Post a Message for Support

Post From: simple alert formula

[2015-10-26 00:54:48]
[Go To First Post]
Sawtooth - Posts: 4000
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.