Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 15:57:11 +0000
Post From: swing high low ?
| [2015-12-15 06:22:06] |
| Sawtooth - Posts: 4000 |
|
Richard, Try these formulas: K3: =IF(AND(Q3,R3=1,AA3>0),AA3,K4) L3: =IF(AND(Q3,R3>0),TRUE,IF(Q3=FALSE,FALSE,L4)) M3: =IF(L3,K3,0) N3: =IF(AND(Q3,S3=1,AB3>0),AB3,N4) O3: =IF(AND(Q3,S3>0),TRUE,IF(Q3=FALSE,FALSE,O4)) P3: =IF(O3,N3,0) Q3: =AND(WEEKDAY(A3)>1,WEEKDAY(A3)<7,A3-INT(A3)>TIMEVALUE("09:30:01"),A3-INT(A3)<TIMEVALUE("16:15:00")) R3: =IF(Q3=FALSE,0,IF(AND(Q3,AA3>0),R4+1,R4)) S3: =IF(Q3=FALSE,0,IF(AND(Q3,AB3>0),S4+1,S4)) -Tom Date Time Of Last Edit: 2015-12-16 00:52:33
|