Support Board
Date/Time: Mon, 03 Feb 2025 10:04:12 +0000
Post From: Wanting to use crossfromabove twice
| [2019-11-04 01:36:08] |
| Sawtooth - Posts: 4164 |
|
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)) |