Support Board

Date/Time: Sat, 01 Nov 2025 16:34:26 +0000

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

[2017-10-06 22:51:34] Link To Thread - Link To Post [Go To First Post]
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?