Support Board

Date/Time: Sat, 19 Apr 2025 09:15:34 +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: 39362
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