Login Page - Create Account

Support Board


Date/Time: Fri, 29 Nov 2024 23:34:54 +0000



Post From: 2 conditions in the same cell

[2023-01-06 19:37:35]
Hopeman - Posts: 166
Sierra chart does not recognize the formulas described with any of the variations described, it must have a different language than excel since I cannot get it to recognize the order or the formula described


=IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5), CROSSFROMBELOW(AM3:AM5,AW3:AW5)),O3,Q3)),IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5),CROSSFROMBELOW(AM3:AM5,AV3:AV5)),O3,Q3))
Date Time Of Last Edit: 2023-01-06 19:40:28