Support Board
Date/Time: Sat, 14 Feb 2026 22:06:53 +0000
Post From: Spreadsheet latch cell
| [2025-12-30 16:55:49] |
| Sawtooth - Posts: 4313 |
|
To test this example, do these steps: 1. Put this formula in H3: =AND(OR(H3=TRUE,H4>1),H5) 2. Put 1 in H4. 3. Put 1 in H5. 4. Put 2 in H4. H3 goes from 0 to 1. 5. Put 1 in H4. H3 stays 1 after the locking condition is removed. 6. Put 0 in H5. H3 goes to 0, lock is released. 7. Put 1 in H5. H3 stays 0, ready for the next lock. Note: This does not work in Excel. This only works in Sierra spreadsheets. |