Support Board
Date/Time: Mon, 25 Nov 2024 12:50:18 +0000
Post From: Combining two conditions in spreadsheet studies
| [2014-01-28 01:37:03] |
| Sawtooth - Posts: 4120 |
|
Try this: =OR(AND(AA4>E4;E3>AA3;AE3>AF3);AND(E3>AA3;AE4<AF4;AE3>AF3)) This will signal when the MAs cross and the PSAR has already changed direction, OR when the PSAR changes direction and the MAs have already crossed. |