Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 16 Sep 2024 19:19:53 +0000
Post From: TRUE condition for MA Slope ?
| [2015-03-25 01:26:14] |
| Sawtooth - Posts: 4091 |
|
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) |