Support Board

Date/Time: Fri, 03 May 2024 13:11:19 +0000

Post From: sort of a statete machine in a spreadsheet

[2014-06-05 14:00:13] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3992
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