Login Page - Create Account

Support Board


Date/Time: Thu, 16 Jan 2025 08:54:06 +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: 4153
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.