View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Keith74 Keith74 is offline
external usenet poster
 
Posts: 120
Default If a cell contains a certain value

Hi

This seems to work, someone else might have a better solution

=IF(ISERROR(SEARCH("GLOBAL",A1) ) = TRUE,0,1)

hth

Keith