Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 28 Oct 2024 11:18:01 +0000
Post From: Spreadsheet for Trading = saving a value
| [2015-07-20 17:25:09] |
| Sawtooth - Posts: 4100 |
|
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
|