Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 13:54:42 +0000

How to Post a Message for Support

Post From: Wanting to use crossfromabove twice

[2019-11-04 01:36:08]
[Go To First Post]
Sawtooth - Posts: 4000
The IF function is If,Then,Else. So: If( J48 < X, Then 0, Else Crossfrombelow...)

You also need to define the conditions in the range.

Try this:
=IF($J$48<MIN(E3:E6),0,CROSSFROMBELOW(ID4.SG1@3:ID4.SG1@6,ID6.SG1@3:ID6.SG1@6)

Since the Then is zero, you could use this:
=AND($J$48>MIN(E3:E6),CROSSFROMBELOW(ID4.SG1@3:ID4.SG1@6,ID6.SG1@3:ID6.SG1@6))