Cell C1 ="error" if....
 

I wish to return the text "Error" in cell C1 if the text "error"
appears in any cell in the range AF3:AF52. Cells in the range
AF3:AF52 contain a formula that reurns "error" if there should be a
problem in that row.
Can anyone advise?
Thanks to all,
Dave Moore

Enter the following formula in C1:

=IF(COUNTIF(AF3:AF52,"Error")0,"Error","")


Mangesh



"DaveMoore" wrote in message
oups.com...
I wish to return the text "Error" in cell C1 if the text "error"
appears in any cell in the range AF3:AF52. Cells in the range
AF3:AF52 contain a formula that reurns "error" if there should be a
problem in that row.
Can anyone advise?
Thanks to all,
Dave Moore

Thanks, Mangesh.
Simple really, wasn't it?
But I couldn't see it!