Spreadsheet: 143987d1330656419-help-fixing-if-and-formula-example2
Sheet: Example

Date | Time | Close | Value "A" | 1st Value "A"
2000-12-17 00:00:00 | 14:00:00 | 0.8944 | 0.8959514285714286 | /
2000-12-17 00:00:00 | 14:15:00 | 0.8945 | 0.8959514285714286 | /
2000-12-17 00:00:00 | 14:30:00 | 0.8945 | 0.8959514285714286 | / |  | Starting at 16:00 hours.
2000-12-17 00:00:00 | 14:45:00 | 0.8948 | 0.8959514285714286 | / |  | I need a formula that looks for the first instance that the close in colum C is >= to Value "A" in column D.
2000-12-17 00:00:00 | 15:00:00 | 0.8949 | 0.8959514285714286 | / |  | I'm looking for the first instance only. Any instance after should be False.
2000-12-17 00:00:00 | 15:15:00 | 0.8943 | 0.8959514285714286 | / |  | The cycle would repeat at 16:00 hours the next day with a new Value "A".
2000-12-17 00:00:00 | 15:30:00 | 0.8944 | 0.8959514285714286 | / |  | As you can see the forumula I'm currently using doesn't fit that requirement.
2000-12-17 00:00:00 | 15:45:00 | 0.8949 | 0.8959514285714286 | / |  | Any help with this would be greatly appreciated.
2000-12-17 00:00:00 | 16:00:00 | 0.8952 | 0.8959514285714286 | 0
2000-12-17 00:00:00 | 16:15:00 | 0.8957 | 0.8959514285714286 | FALSE | C11 is not greater than or equal to D11, so it's False.
2000-12-17 00:00:00 | 16:30:00 | 0.8954 | 0.8959514285714286 | FALSE | C12 is not greater than or equal to D12, so it's False.
2000-12-17 00:00:00 | 16:45:00 | 0.8952 | 0.8959514285714286 | FALSE | C13 is not greater than or equal to D13, so it's False.
2000-12-17 00:00:00 | 17:00:00 | 0.8955 | 0.8959514285714286 | FALSE | C14 is not greater than or equal to D14, so it's False.
2000-12-17 00:00:00 | 17:15:00 | 0.8957 | 0.8959514285714286 | FALSE | C15 is not greater than or equal to D15, so it's False.
2000-12-17 00:00:00 | 17:30:00 | 0.8953 | 0.8959514285714286 | FALSE | C16 is not greater than or equal to D16, so it's False.
2000-12-17 00:00:00 | 17:45:00 | 0.8951 | 0.8959514285714286 | FALSE | C17 is not greater than or equal to D17, so it's False.
2000-12-17 00:00:00 | 18:00:00 | 0.8949 | 0.8959514285714286 | FALSE | C18 is not greater than or equal to [NAME], so it's False.
2000-12-17 00:00:00 | 18:15:00 | 0.8955 | 0.8959514285714286 | FALSE | C19 is not greater than or equal to [NAME], so it's False.
2000-12-17 00:00:00 | 18:30:00 | 0.8953 | 0.8959514285714286 | FALSE | C20 is not greater than or equal to D20, so it's False.
2000-12-17 00:00:00 | 18:45:00 | 0.8956 | 0.8959514285714286 | FALSE | C21 is not greater than or equal to D21, so it's False.
2000-12-17 00:00:00 | 19:00:00 | 0.8954 | 0.8959514285714286 | FALSE | C22 is not greater than or equal to D22, so it's False.
2000-12-17 00:00:00 | 19:15:00 | 0.8958 | 0.8959514285714286 | FALSE | C23 is not greater than or equal to D23, so it's False.
2000-12-17 00:00:00 | 19:30:00 | 0.896 | 0.8959514285714286 | TRUE | True because all previous cells are false and because C24 >= D24
2000-12-17 00:00:00 | 19:45:00 | 0.8957 | 0.8959514285714286 | FALSE | Should be false, because E24 is the first True instance of the day.
2000-12-17 00:00:00 | 20:00:00 | 0.8957 | 0.8959514285714286 | FALSE | Should be false, because E24 is the first True instance of the day.
2000-12-17 00:00:00 | 20:15:00 | 0.8957 | 0.8959514285714286 | FALSE | Should be false, because E24 is the first True instance of the day.
2000-12-17 00:00:00 | 20:30:00 | 0.8967 | 0.8959514285714286 | TRUE | Should be false, because E24 is the first True instance of the day.
2000-12-17 00:00:00 | 20:45:00 | 0.8964 | 0.8959514285714286 | TRUE | Should be false, because E24 is the first True instance of the day.
2000-12-17 00:00:00 | 21:00:00 | 0.8962 | 0.8959514285714286 | Etc.
2000-12-17 00:00:00 | 21:15:00 | 0.8963 | 0.8959514285714286 | Etc.
2000-12-17 00:00:00 | 21:30:00 | 0.8975 | 0.8959514285714286
2000-12-17 00:00:00 | 21:45:00 | 0.8977 | 0.8959514285714286
2000-12-17 00:00:00 | 22:00:00 | 0.8983 | 0.8959514285714286
2000-12-17 00:00:00 | 22:15:00 | 0.8985 | 0.8959514285714286
2000-12-17 00:00:00 | 22:30:00 | 0.8985 | 0.8959514285714286
2000-12-17 00:00:00 | 22:45:00 | 0.8994 | 0.8959514285714286
2000-12-17 00:00:00 | 23:00:00 | 0.8993 | 0.8959514285714286
2000-12-17 00:00:00 | 23:15:00 | 0.8982 | 0.8959514285714286
2000-12-17 00:00:00 | 23:30:00 | 0.8976 | 0.8959514285714286
2000-12-17 00:00:00 | 23:45:00 | 0.901 | 0.8959514285714286
2000-12-18 00:00:00 | 1900-01-01 00:00:00 | 0.9011 | 0.8959514285714286
2000-12-18 00:00:00 | 00:15:00 | 0.8988 | 0.8959514285714286
2000-12-18 00:00:00 | 00:30:00 | 0.8983 | 0.8959514285714286
2000-12-18 00:00:00 | 00:45:00 | 0.8981 | 0.8959514285714286
2000-12-18 00:00:00 | 01:00:00 | 0.8976 | 0.8959514285714286
2000-12-18 00:00:00 | 01:15:00 | 0.8979 | 0.8959514285714286
2000-12-18 00:00:00 | 01:30:00 | 0.8979 | 0.8959514285714286
2000-12-18 00:00:00 | 01:45:00 | 0.8978 | 0.8959514285714286
2000-12-18 00:00:00 | 02:00:00 | 0.8971 | 0.8959514285714286
2000-12-18 00:00:00 | 02:15:00 | 0.8978 | 0.8959514285714286
2000-12-18 00:00:00 | 02:30:00 | 0.8974 | 0.8959514285714286
2000-12-18 00:00:00 | 02:45:00 | 0.8969 | 0.8959514285714286
2000-12-18 00:00:00 | 03:00:00 | 0.8966 | 0.8959514285714286
2000-12-18 00:00:00 | 03:15:00 | 0.8959 | 0.8959514285714286
2000-12-18 00:00:00 | 03:30:00 | 0.8967 | 0.8959514285714286
2000-12-18 00:00:00 | 03:45:00 | 0.8961 | 0.8959514285714286
2000-12-18 00:00:00 | 04:00:00 | 0.8957 | 0.8959514285714286
2000-12-18 00:00:00 | 04:15:00 | 0.8957 | 0.8959514285714286
2000-12-18 00:00:00 | 04:30:00 | 0.8954 | 0.8959514285714286
2000-12-18 00:00:00 | 04:45:00 | 0.8947 | 0.8959514285714286
2000-12-18 00:00:00 | 05:00:00 | 0.8959 | 0.8959514285714286
2000-12-18 00:00:00 | 05:15:00 | 0.8956 | 0.8959514285714286
2000-12-18 00:00:00 | 05:30:00 | 0.8956 | 0.8959514285714286
2000-12-18 00:00:00 | 05:45:00 | 0.8954 | 0.8959514285714286
2000-12-18 00:00:00 | 06:00:00 | 0.8948 | 0.8959514285714286
2000-12-18 00:00:00 | 06:15:00 | 0.8955 | 0.8959514285714286
2000-12-18 00:00:00 | 06:30:00 | 0.8965 | 0.8959514285714286
2000-12-18 00:00:00 | 06:45:00 | 0.8963 | 0.8959514285714286
2000-12-18 00:00:00 | 07:00:00 | 0.895 | 0.8959514285714286
2000-12-18 00:00:00 | 07:15:00 | 0.8954 | 0.8959514285714286
2000-12-18 00:00:00 | 07:30:00 | 0.8953 | 0.8959514285714286
2000-12-18 00:00:00 | 07:45:00 | 0.8957 | 0.8959514285714286
2000-12-18 00:00:00 | 08:00:00 | 0.8944 | 0.8959514285714286
2000-12-18 00:00:00 | 08:15:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 08:30:00 | 0.8931 | 0.8959514285714286
2000-12-18 00:00:00 | 08:45:00 | 0.8925 | 0.8959514285714286
2000-12-18 00:00:00 | 09:00:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 09:15:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 09:30:00 | 0.8931 | 0.8959514285714286
2000-12-18 00:00:00 | 09:45:00 | 0.8929 | 0.8959514285714286
2000-12-18 00:00:00 | 10:00:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 10:15:00 | 0.8937 | 0.8959514285714286
2000-12-18 00:00:00 | 10:30:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 10:45:00 | 0.8933 | 0.8959514285714286
2000-12-18 00:00:00 | 11:00:00 | 0.8931 | 0.8959514285714286
2000-12-18 00:00:00 | 11:15:00 | 0.8933 | 0.8959514285714286
2000-12-18 00:00:00 | 11:30:00 | 0.8938 | 0.8959514285714286
2000-12-18 00:00:00 | 11:45:00 | 0.8934 | 0.8959514285714286
2000-12-18 00:00:00 | 12:00:00 | 0.8943 | 0.8959514285714286
2000-12-18 00:00:00 | 12:15:00 | 0.8939 | 0.8959514285714286
2000-12-18 00:00:00 | 12:30:00 | 0.8938 | 0.8959514285714286
2000-12-18 00:00:00 | 12:45:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 13:00:00 | 0.8936 | 0.8959514285714286
2000-12-18 00:00:00 | 13:15:00 | 0.8941 | 0.8959514285714286
2000-12-18 00:00:00 | 13:30:00 | 0.8945 | 0.8959514285714286
2000-12-18 00:00:00 | 13:45:00 | 0.8952 | 0.8959514285714286