Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 19 Sep 2024 21:37:32 +0000

How to Post a Message for Support

Post From: spreadsheet problem

[2013-12-25 01:30:29]
[Go To First Post]
Sawtooth - Posts: 4091
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.