IF function with 3 consecutive condition

[Researchstudent]

Hello,

I need to write a formula to determine whether an event took place or not. Definition of event is at least 3 consecutive column cells with a value lower than 65. I would like to determine this for a certain period of time, for example in the coming 5 minutes. Every cell represents 20 seconds, so for 5 minutes I will be looking at 15 cells. The question is: are there 3 consecutive values lower than 65 within the 15 cells? If yes, give 1 (event), if no give 0 (no event) . It can also be more than 3 consecutive cells, but it should be at least 3 consecutive values

If I write IF(A1:A15<65;"1";"0") then I am not including the at least 3 consecutive condition. How can I do this?

Here is an example of what my data look like, and I manually added 1 to indicate that the formula should give a 1 in this case

 

[C Moore]

The helper column meant the whole range.