Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Wed, 24 Apr 2024 08:03:26 +0000
Post From: Combining two conditions in spreadsheet studies
| [2014-01-30 03:03:01] |
| Sawtooth - Posts: 3976 |
|
What you want to do is more complicated than combining OR and AND statements. It requires formulas in several columns, using double IF statements, the first to start a TRUE, the second to end the TRUE. For example, a buy entry: K3: =AND(O3,P3) O3: =IF(AND(AA4>E4,E3>AA3),TRUE,IF(AND(AE5<AF5,AE4>AF4),FALSE,O4)) P3: =IF(AND(AE4<AF4,AE3>AF3),TRUE,IF(AND(AA5>E5,E4>AA4),FALSE,P4)) Notice the end TRUE offsets the rows by one row. |