Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 18 Apr 2024 14:10:29 +0000

How to Post a Message for Support

Post From: Combining two conditions in spreadsheet studies

[2014-01-28 01:37:03]
[Go To First Post]
Sawtooth - Posts: 3973
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.