Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 03:52:20 +0000

How to Post a Message for Support

Post From: How to combine two crossfromabove statements

[2019-08-30 22:28:19]
[Go To First Post]
Sawtooth - Posts: 4000
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.