Support Board
Date/Time: Sun, 22 Dec 2024 05:51:38 +0000
Post From: Spreadsheet for Trading = saving a value
| [2015-07-20 17:25:09] |
| Sawtooth - Posts: 4141 |
|
Use a double IF statement, like this e.g. in P3: =IF(CROSSFROMBELOW(AB3:AB4,AC3:AC4),TRUE,IF(CROSSFROMABOVE(AB3:AB4,AC3:AC4),FALSE,P4)) The first IF starts the persistent TRUE, the second IF ends it. You will probably want to use something besides the opposite crossover to end it; this is just an example. Then in another column, e.g. Q3: =AND(P3,CROSSFROMBELOW(AE3:AE4,AG3:AG4)) Date Time Of Last Edit: 2015-07-20 18:31:36
|