Support Board
Date/Time: Fri, 31 Jan 2025 03:04:39 +0000
Post From: lock variable function issue
| [2019-04-05 19:26:26] |
| User917679 - Posts: 76 |
|
If either of the ORs are true, it stops evaluating, and returns TRUE.
Right, but for example, in the code corresponding to the detail analysis image: 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) ) In my case above, it seems that when the first and second "AND()" clauses went false, V3 still came up with a TRUE reading somehow(?) I don't see where/why V3 became true tbh.. Is it possible that the spreadsheet program is carrying over the "previous V3's" TRUE via some strange delay? |