Login Page - Create Account

Support Board


Date/Time: Wed, 17 Sep 2025 11:48:18 +0000



Post From: How to combine two crossfromabove statements

[2019-08-30 22:28:19]
Sawtooth - Posts: 4263
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.