Support Board

Date/Time: Fri, 29 Nov 2024 23:58:09 +0000

Post From: 2 conditions in the same cell

[2023-01-06 23:08:03] Link To Thread - Link To Post [Go To First Post]
John - SC Support - Posts: 36350
You need to nest the IF statements. right now you have two separate IF statements that will not work (it would not work in Excel either). The nesting of IF statements works exactly the same in Sierra Chart as it does in Excel. You need to do the following: =IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5), CROSSFROMBELOW(AM3:AM5,AW3:AW5)),O3,IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5),CROSSFROMBELOW(AM3:AM5,AV3:AV5)),O3, Q3)) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing