View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen53 Karen53 is offline
external usenet poster
 
Posts: 333
Default If statement to compare for wildcard value in another cell.

Hello,

I need to compare for a value contained within another cell. I need to test
for a portion within the cell so I'm using wildcards. I have tried various
combinations but it's not working. What am I missing?

Here is one I've tried.

=IF(n2=*g2*,1,0)

Thanks for your help,