Support Board
Date/Time: Mon, 25 Nov 2024 12:52:26 +0000
Post From: Combining two conditions in spreadsheet studies
| [2014-01-28 17:33:09] |
| Sawtooth - Posts: 4120 |
|
Try these: 1) =AND(AA4>E4;E3>AA3;AE4<AF4;AE3>AF3) This will signal when both are TRUE in the same bar. You can also do it this way if it is clearer for you: =AND(AND(AA4>E4;E3>AA3);AND(AE4<AF4;AE3>AF3)) 2) =OR(AND(AA4>E4;E3>AA3);AND(AE4<AF4;AE3>AF3)) This will signal when either are TRUE. |