Login Page - Create Account

Support Board


Date/Time: Thu, 16 Jan 2025 09:06:27 +0000



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

[2017-10-06 22:51:34]
User29926 - Posts: 92
Using only one condition to unlock the cell works
=AND(OR(H3=TRUE,H4>1),H5=0)

But adding an additional condition and the unlock does not work anymore
=AND(OR(H3=TRUE,H4>1), OR(H5=0,H6=0) )

Even this write up only uses one condition to unlock:
Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition

Does this unlock feature only work with one unlocking condition?