Wildcard Character in IF formulas

[lightbulb]

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!

 

[Pete_UK]

Try it like this:

=IF(OR(LEFT(H8,1)="E",LEFT(H8,1)="R"),AA12,0)

Hope this helps.

Pete

 

[M Kan]

you can use this as your conditional test

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

COUNTIF and SUMIF support wildcards