Login Page - Create Account

Support Board


Date/Time: Sat, 13 Sep 2025 12:48:07 +0000



Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0

[2017-10-07 00:30:51]
Sawtooth - Posts: 4263
Does this unlock feature only work with one unlocking condition?
It seems when more than one cell is included in the reset formula, the spreadsheet will not automatically recalculate.

If you go through the steps to lock and unlock, then you go to Spreadsheet >> Recalculate All Formulas, H3 will reset.

Does this work in an active chart with live or replay data? It should.