Support Board
Date/Time: Mon, 25 Nov 2024 02:03:40 +0000
Post From: spreadsheet problem
| [2013-12-24 23:17:43] |
| toews&kane - Posts: 209 |
|
I am finding a problem H8 holds =AND(J41-INT(J41)>=TIMEVALUE("13:00:00"),J41-INT(J41)<TIMEVALUE("14:00:00")) H9 holds =AND(OR(AND(H8=TRUE, CT3<=-4000),H10>1),H11=FALSE) H10 holds a counter to hold the condition true =IF($H$8=TRUE, H10+1,IF(INT(A3)>INT(A4), 1, H10)) H11 is the release on the lock =INT(A3)>INT(A4) The issue is H9 goes to true automatically without evaluation ct3<=-4000. how can that happen? |