Formula for If the last 5 cells did not contain number 11, insert number 11

[ceexcee1]

Hi Community,

I am looking for a formula which can return this for me.

Cells

A1 = 12
A2 = 13
A3 = 4
A4 = 16
A5 = 15


In Cell B6, I want a formula that if the previous 5 cells in the column to the left did not contain the number 11 in any of the cells, put 11 into Cell B6

Would appreciate any help please =D

[FDibbins]

Hi, welcome to the forum

Perhaps this?
=IF(COUNTIF(A1:A5,11)=0,11,"")

[ceexcee1]

Hi Fdibbins,

Thank you for your help! That was exactly what I needed =D