Support Board
Date/Time: Sun, 02 Feb 2025 09:55:06 +0000
Post From: How to combine two crossfromabove statements
| [2019-08-30 22:28:19] |
| Sawtooth - Posts: 4164 |
|
Try this: =OR(AND(CROSSFROMABOVE(AA3:AA6,AB3:AB6),AF3<AG3),AND(CROSSFROMABOVE(AF3:AF6,AG3:AG6),AA3<AB3)) This will signal when one CROSSFROMABOVE crosses and the other has already crossed. |