Thread: Wildcard Character in IF formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default Wildcard Character in IF formulas
you can use this as your conditional test

OR(COUNTIF(G46,"*A*"),COUNTIF(G46,"*A*"))

COUNTIF and SUMIF support wildcards

--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"lightbulb" wrote:

Is it possible to use wildcard characters in an IF formula? I tried
=IF(OR(H8="E*",H8="R*")=TRUE,AA12,0) but this did not work. Any help would
be appreciated

Thanks!
Reply With QuoteReply With Quote