Support Board
Date/Time: Tue, 21 Apr 2026 08:33:22 +0000
Post From: Combining two conditions in spreadsheet studies
| [2014-01-28 01:37:03] |
| Sawtooth - Posts: 4327 |
|
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. |