Support Board
Date/Time: Thu, 16 Jan 2025 08:58:52 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2017-10-08 00:59:13] |
| Sawtooth - Posts: 4153 |
|
If H4 remains >1, H3 will toggle locked/unlocked as H5 toggles TRUE/FALSE. Forcing the recalc in this situation does not unlock H3. H4 must be <2 before even a 'Recalculate All Formulas' will reset H3. Or follow the process where H4 must be <2, then H5 must become FALSE then TRUE, before H3 is ready to lock again. Use the blue cells to see manually how it is supposed to work. Automatically unlocking a locked TRUE cell can be convoluted in even simple cases. Forcing a recalc would probably make it more so because you'd have to do it at a certain point in the process. In my experience, using a locked condition TRUE formula is only needed in rare occasions. A more reliable solution is to create a persistent variable in a Formula Column. If you want to discuss this privately, contact me here: http://www.sawtoothtrade.com/contact.html |