Support Board
Date/Time: Fri, 29 Nov 2024 23:47:07 +0000
Post From: 2 conditions in the same cell
| [2023-01-06 18:01:15] |
| John - SC Support - Posts: 36350 |
|
Your ANDs and your ORs are not placed correctly. The AND and OR take a comma delimited set of items and determines the individual results and then tests against the individual items. Such as AND(Condition1, Condition2) where both Condition1 and Condition2 need to be True for the AND to be True. But you have the AND for a single item, which is not needed and will not work. For example, your Formula 1 should be the following: =IF(AND(CROSSFROMBELOW(E3:E5,AB3:AB5), CROSSFROMBELOW(AM3:AM5,AW3:AW5)),O3,Q3) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |