Support Board

Date/Time: Fri, 29 Nov 2024 23:59:24 +0000

Post From: 2 conditions in the same cell

[2023-01-06 15:23:48] Link To Thread - Link To Post [Go To First Post]
Hopeman - Posts: 166
Dear support, I am trying to give two separate input conditions for the same cell and Sierra Chart only recognizes one, My question is if it is possible to combine two different conditions in the same cell since I have tried different variations and Sierra Chart only recognizes the first one, thanks These are the formulas First =AND(CROSSFROMBELOW(E3:E5,AB3:AB5),AND(CROSSFROMBELOW(AM3:AM5,AW3:AW5),O3,Q3) Second =AND(CROSSOVER(E3:E5,AB3:AB5),OR(AM3:AM5,AW3:AW5),O3,Q3) First and second combined =IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5),AND(CROSSFROMBELOW(AM3:AM5,AW3:AW5),O3,Q3)),IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5),OR(AM3:AM5,AW3:AW5),O3,Q3)), "", ""), "") I have tried several combinations and I still do not give the solution. I understand that the program can only read one formula, Thank you