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? |