Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Thu, 19 Sep 2024 21:51:12 +0000
Post From: spreadsheet problem
| [2013-12-23 22:47:41] |
| toews&kane - Posts: 209 |
|
Hi there, Trying to work on this problem for a bit now. I am trying to restrict one condition for this time frame $H$8 =AND(J41-INT(J41)>=TIMEVALUE("13:00:00"),J41-INT(J41)<TIMEVALUE("14:00:00")) with column x refering to it IF($H$8, SOME CONDITION, PREVIOUS CELL VALUE) so that once the condition is met say B3<=-10 it will be flagged true for the rest of the day how do i do this? |