Simple IF not working

[MOB]

=IF($AU10="*:*",$D10,"")

Column AU may contain text like AA:AB or STU:BR1

I was hoping my formula would recognise if a cell had a colon in it, but it isn't!

What am I doing wrong?

TIA

 

[a massive zebra]

=if(countif($au10,"*:*")>0,$d10,"")

 

[Chris Mack]

If you're just wanting to test whether or not the cell contains a colon, this would work:

=IF(ISERROR(SEARCH(":",$AU10,1)),"",$D10)

Hope this helps,

Chris.

 

[MOB]

Thanks Zebra and Chris

 

[Chris Mack]

Yw.