ExcelBanter - Wildcard Character in IF formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Wildcard Character in IF formulas (https://www.excelbanter.com/excel-discussion-misc-queries/196275-wildcard-character-if-formulas.html)

lightbulb

Wildcard Character in IF formulas

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

Wildcard Character in IF formulas

Try it like this:

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

Hope this helps.

Pete

On Jul 25, 1:54*pm, 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!

M Kan

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!

All times are GMT +1. The time now is 05:36 PM.