Login Page - Create Account

Support Board


Date/Time: Sat, 10 May 2025 11:44:25 +0000



Post From: price action study for the time passed meaning that happened before ?

[2015-07-31 12:49:31]
Sawtooth - Posts: 4214
There are various ways create a persistent value that stays in row 3. Here's one example that you might be able to use or modify:
http://www.sawtoothtrade.com/free-stuff-5.html

A way to create a single persistent value is to use double IF statements, where the first IF begins the persistence and the second IF ends it:
=IF(ConditionsForTrue,TRUE,IF(ConditionsForFalse,FALSE,S4))
where the above formula is in cell S3.

You can also lock a TRUE condition with a self-referencing formula. Here's an example:
http://www.sawtoothtrade.com/example-9.html