Wildcard Character in IF formulas

L

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!
 
P

Pete_UK

Try it like this:

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

Hope this helps.

Pete
 
M

M Kan

you can use this as your conditional test

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

COUNTIF and SUMIF support wildcards
 
Top