Support Board
Date/Time: Sat, 12 Jul 2025 06:47:52 +0000
Post From: sort of a statete machine in a spreadsheet
| [2014-06-05 14:00:13] |
| Sawtooth - Posts: 4238 |
|
There are two ways to do this: 1) In a single non-repeating cell, e.g. H3 (not in the array): http://www.sawtoothtrade.com/example-9.html 2) In row 3 of a Formula Column, e.g. O3 (in the array): =IF(StartBuyModeCondition,TRUE,IF(EndBuyModeCondition,FALSE,O4)) The idea is to latch a persistent TRUE with the first IF and release it with the second IF. There are many variations of this and you may need to experiment with the idea. Date Time Of Last Edit: 2015-08-14 02:02:55
|