Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 03 Feb 2025 10:01:29 +0000

How to Post a Message for Support

Post From: Wanting to use crossfromabove twice

[2019-10-08 20:42:39]
[Go To First Post]
Sawtooth - Posts: 4164
The formula in post #7, after corrections:
=AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4),CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),CROSSFROMBELOW(ID2.SG1@3:ID2.SG1@4,ID3.SG1@3:ID3.SG1@4))

If using AND, the formula will only be TRUE if all 3 crossovers occur concurrently, which is probably very unlikely.

Use OR instead of AND if any of the crossovers can individually trigger the signal.

If you want any one of the crossovers to trigger the signal, where the other two have already crossed over, this is what it looks like...:
=OR(
AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4),ID1.SG1@3>ID3.SG1@3,ID2.SG1@3>ID3.SG1@3),
AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),ID1.SG1@3>ID2.SG1@3,ID2.SG1@3>ID3.SG1@3),
AND(CROSSFROMBELOW(ID2.SG1@3:ID2.SG1@4,ID3.SG1@3:ID3.SG1@4),ID1.SG1@3>ID2.SG1@3,ID1.SG1@3>ID3.SG1@3))
But you'll need to copy it from here:
=OR(AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4),ID1.SG1@3>ID3.SG1@3,ID2.SG1@3>ID3.SG1@3),AND(CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID3.SG1@3:ID3.SG1@4),ID1.SG1@3>ID2.SG1@3,ID2.SG1@3>ID3.SG1@3),AND(CROSSFROMBELOW(ID2.SG1@3:ID2.SG1@4,ID3.SG1@3:ID3.SG1@4),ID1.SG1@3>ID2.SG1@3,ID1.SG1@3>ID3.SG1@3))