I have a function that is a "delay" trigger, at the moment it looks in two columns and when it finds an increase it goes from 0 to 1. It also checks if the three cell above is one, and stays so 1 for 3 cells:

=IF(P23>P22,1,IF(O22=1,IF(AND(O21=1,O20=1,O19=0),0 ,1),0))



So the formula checks if the P column is increasing, if so sets to 1.
If the above value is 1 (column O), it is sets to 1 unless there have been 3 consecutive 1s, in which case its sets to 0 (ie the cells above are 1,1,1,0)

Now, the ammount of consecutive ones it checks at the moment is hard-coded. I'd like to have a cell to specify this but I can't think of a way of doing it.

Can anyone help?