View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DamienO DamienO is offline
external usenet poster
 
Posts: 15
Default Using the wildcard with IF

Hi all,
I'm trying to set up a message that will generate from an IF formula. At the
moment I'm at:

=IF(E3="*C3","","Please check that you have chosen")

The content of C3 is a part of the content in E3 e.g. E3=161426 oxygen and
C3=oxygen. I want to check that what is in C3 is also in E3 and, if not, put
up a message. All help appreciated.