Support Board
Date/Time: Tue, 01 Jul 2025 07:35:01 +0000
Post From: Combining two conditions in spreadsheet studies
| [2014-01-28 17:33:09] |
| Sawtooth - Posts: 4231 |
|
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. |