Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Tue, 04 Mar 2025 16:34:23 +0000

How to Post a Message for Support

Post From: Spreadsheet programming question #CREF using Locking the State of a One Time Condition

[2021-12-15 05:46:32]
[Go To First Post]
j4ytr4der_ - Posts: 946
In case it's helpful to anyone... here's another (commented) approach...

=IF(REM="How to set & lock a state","",
  IF(
    AND(
      IF(REM="If state #1 is true...","",""),
      J5 <> 0,
    ),
    AND(
      IF(REM="then set this cell (O3) to true","",""),
      O3 = 1,
    ),
    AND(
      IF(REM="Otherwise keep the value at this cell's value...","",""),
      O3
    )
  )
)

My platform's shut down at the moment so I didn't test this, but it's just a slightly modified copy & paste out of a project I'm working on right now so... reasonably certain it's lacking in huge errors. Reasonably. =D Obviously it can be cleaned up & condensed without all the comments, just including them to help folks understand the logic.