Support Board
Date/Time: Sat, 14 Feb 2026 06:40:41 +0000
Post From: How to combine two crossfromabove statements
| [2019-08-30 22:28:19] |
| Sawtooth - Posts: 4313 |
|
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. |