Support Board
Date/Time: Fri, 31 Jan 2025 02:57:30 +0000
Post From: lock variable function issue
| [2019-04-05 22:59:18] |
| User917679 - Posts: 76 |
|
OR( AND(ID33.SG8@4>ID33.SG7@4,ID25.SG1@4>ID25.SG4@4,ID68.SG1@4>ID68.SG4@4,ID51.SG1@4>ID51.SG4@4,ID51.SG1@5>ID51.SG4@5,ID51.SG1@6>ID51.SG4@6,ID72.SG1@4>ID72.SG4@4,ID74.SG1@4<ID74.SG1@5,ID84.SG1@4<ID84.SG1@5),OR( AND(ID85.SG1@7>ID85.SG4@7,ID86.SG1@7>ID86.SG4@7,ID33.SG8@4>ID33.SG7@4,ID72.SG1@3>ID72.SG4@3,ID68.SG1@3>ID68.SG4@3,ID74.SG1@4<ID74.SG1@5,ID84.SG1@3<ID84.SG1@4,ID78.SG1@3<ID78.SG2@3) ,V3>0) )
^^This is essentially the formula section thats acting up.. and by lock clause, I was refering to the lock in the code formation from above: "OR( AND(), OR( AND(),V3>0) )" to basically lock the whole secondary condition if it becomes TRUE. In the main formula, I put the "ID74.SG1@4<ID74.SG1@5" of the second "AND()" in bold to just to highlight that this condition is NOT met in the image example(nor is the first), and therefore the rest of the statement should NEVER ring true Again, its strange because from the image I sent, the spreadsheet asserts correctly that neither AND() is true - So the V3 being TRUE(in the red box of picture) confuses me... |