Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 19 Sep 2024 21:59:11 +0000

How to Post a Message for Support

Post From: spreadsheet problem

[2013-12-24 23:17:43]
[Go To First Post]
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?