Support Board
Date/Time: Sat, 30 Aug 2025 08:50:07 +0000
Post From: spreadsheet problem
| [2013-12-25 01:30:29] |
| Sawtooth - Posts: 4261 |
|
I think the locking formula should be this: =AND(OR(H9=TRUE,AND(CT3<=-4000,H10>1)),H11=FALSE) The locking TRUE formula should reference its own cell (H9), and the second part of the OR statement is the condition that initiates the TRUE. |