Help finding specific instance in a range

[smonczka]

Hello All,

I am trying to help my son with his homework. He has several rows of cells where if any one cell equels n then the row is false.

For example n=Blue
A1,B1,C1,D1,E1 returns F1
Blue,Red,Red,Orange,Red False
Red,Red,Orange,Brown,Red True

Is there a formula that looks for a specific instance in a range and returns true or false?

Thanks for the help.

Steve Monczka

 

[Brian from Maui]

you can try something like,

=IF(COUNTIF(A1:E1,"Blue")>=1,"False","True")

You can replace blue with a cell reference also.

 

[smonczka]

Thanks!

That worked great, thank Brian from Maui.