Support Board
Date/Time: Sat, 18 May 2024 16:54:14 +0000
Post From: Wanting to use crossfromabove twice
[2019-10-08 20:42:39] |
Sawtooth - Posts: 4000 |
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))
|