Return a value based on cells above the referenced cell

Hi All,

Trying to wrap my head around creating a formula for the cell to return values based on the values above a referenced cell. Example I'm trying to make Column C return "Y"s for any value that is equal or less than 10 in column B, and if it is higher than 10 that it will return "N" for 4 rows after that. E.g.

B2 = 13 so, C2 = N

^ value above 10

B3 = 0 so, C3 = N

^ 1st row after a value above 10

B4 = 0 so, C4 = N

^ 2nd row after a value above 10

B5 = 0 so, C5 = N

^ 3rd row after a value above 10

B6 = 0 so, C6 = N

^ 4th row after a value above 10

B7 = 0 so, C7 = Y

^ after the 4th row where the referenced cell was higher than 10 return value is Y

B8 = 0 so, C8 = Y

^ after the 4th row where the referenced cell was higher than 10 return value is Y

B9 = 0 so, C9 = Y

^ after the 4th row where the referenced cell was higher than 10 return value is Y

B10 = 0 so, C10 = Y

^ after the 4th row where the referenced cell was higher than 10 return value is Y

B11 = 0 so, C11 = Y

^ after the 4th row where the referenced cell was higher than 10 return value is Y

Has anyone created a query like this? Please help. I also attached the workbook as to which I'm working on.

Thanks,

Raymond