Login Page - Create Account

Support Board


Date/Time: Wed, 08 May 2024 22:54:14 +0000



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

[2015-07-31 12:49:31]
Sawtooth - Posts: 3993
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