referencing text in an IF statement

[Michelle Thompson]

I am trying to use an IF statement to look for text in range of cells but
cannot get it to return the value I want I think because I'm searching for
text not a value. If any cell in a column contains the text "Error" I want
the cell I'm in to also read "Error". Here's the formula I have but it won't
work: =IF(OR(A122:A457="Error"),"Error",""). Any suggestions?

 

[Eduardo]

Hi,
try

=if(COUNTIF(a122:a457,"Error")>0,"Error","")

 

[p45cal]

*ARRAY-ENTERED*:
=IF(SUM(--(NOT(ISERR(SEARCH("Error",A122:A457)))))>0,"Error","All OK")

 

[Michelle Thompson]

thanks so much they both worked!