ExcelBanter - referencing text in an IF statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - referencing text in an IF statement (https://www.excelbanter.com/excel-worksheet-functions/250143-referencing-text-if-statement.html)

Michelle Thompson

referencing text in an IF statement

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

referencing text in an IF statement

Hi,
try

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

"Michelle Thompson" wrote:

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?

All times are GMT +1. The time now is 03:54 PM.