Support Board
Date/Time: Tue, 04 Mar 2025 16:31:38 +0000
Post From: Spreadsheet programming question #CREF using Locking the State of a One Time Condition
| [2021-12-13 00:51:33] |
| Sawtooth - Posts: 4179 |
|
The example does not create a #CREF. Try this exercise: 1. Put this formula in cell H3: =AND(OR(H3=TRUE,H4>1),H5) 2. Put a 1 in both H4 and H5. H3 will be 0, and ready to be locked. 3. Put a 2 in H4. H3 will go to 1, and be locked. 4. Put a 1 in H4. H3 remains a 1 because it is locked. 5. Put a 0 in H5. H3 will go to 0, and be unlocked, but not ready to be locked again. 6. Put a 1 in H5. H3 remains a 0, but is ready to be locked again. I admit it can be tricky to get this to work automatically, especially the unlocking and rearming portion. Steps 3 & 4 can easily be done automatically because this is the event that you want to lock TRUE. Steps 5 & 6 can be tricky to get to work automatically because you need an event that changes state, followed by a change of state in the opposite direction. IOW, step 5 can be 0, and step 6 can be 1, or vice versa if H5=0. |