Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 19 Apr 2024 23:58:30 +0000
Post From: Combining two conditions in spreadsheet studies
| [2014-01-28 17:33:09] |
| Sawtooth - Posts: 3975 |
|
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. |