Thread: Can IF do this?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Can IF do this?

Try this in A1:

=COUNTIF(C:C,"xyz")0

Hope this helps.

Pete

On Jun 28, 11:47 pm, "D.P. Roberts" wrote:
I'd like to have a function in cell A1 that does the following:

If Column C contains the text string "xyz" in any of its cells, display
"true"; if not, display "false"

Is this possible?