Researchstudent
New Member
- Joined
- Jan 11, 2021
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
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
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