Support Board
Date/Time: Sun, 22 Dec 2024 05:41:44 +0000
Post From: TRUE condition for MA Slope ?
[2015-03-25 01:26:14] |
Sawtooth - Posts: 4141 |
I use something like this, e.g. in X3: =IF(AND(AA5>=AA4,AA3>AA4),"UP",IF(AND(AA5<=AA4,AA3<AA4),"DN",X4)) Where the MA is in column AA Then in Y3, for an up arrow: =IF(AND(X4="DN",X3="UP"),D3,0) and in Z3, for a down arrow: =IF(AND(X4="UP",X3="DN"),C3,0) |