Return a value if a range of cells contain a specific number.

[fleeboing]

Hi all,

Would anyone know a formula I could use to return a result e.g. "True " or "False" if a range of cells contain certain specific numbers?

I've tried online to find it but I can't find one that allows a range of cells to be checked for a series of specific numbers.

Simple image attached.

Thanks in advance for any help!!

Alan

[efvba]

e.g. =COUNTIF(A2:B20,2)+COUNTIF(A2:B20,15)+COUNTIF(A2:B20,4)>0

[fleeboing]

Hi efvba, that worked a treat. I just tweaked the range and added the numbers I wanted it to look for... you are a legend thank you!!!!!