Wild card not working

[Gaius-Harmonius]

Hi, can someone explain why this wild card isnt woring? Yes i have them enabeled, i even have one working on a different sheet with no difference that i can see.
thanks!

[EarnestAl]

You probably need something like =IF(ISNA(MATCH("N*";B9;0));0;1)
See Calculate

[fpy]

@Gaius-Harmonius

working

is it ?

Wildcards in IF Function with Text

Direct comparison neither suppports wildcards nor RegEx, You can use =IF(RIGHT(T37;LEN("Bifold"))="Bifold";"2 DR BF";"Bob") . (Strange design.) … If you actually need to get more flexibility with the help of RegEx search, explain more precisely what you want to achieve, and attach a respectice example file.

[Gaius-Harmonius]

i found a work around using ISNUMBER(), but would really like to understand what im doing wrong. the wildcard works fine a COUNTIFS equation. does it really not work in IF?

[robleyd]

@Gaius-Harmonius

does it really not work in IF?

According to the HELP, no. Scroll down to Supported Spreadsheet Functions.

[EarnestAl]

@Gaius-Harmonius

eally like to understand what im doing wrong

From the help I linked

Enable wildcards in formulae

Specifies that wildcards are enabled when searching and also for character string comparisons. This relates to the database functions, and to LOOKUP, VLOOKUP, HLOOKUP, MATCH, AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and SEARCH.

The simplest formula, =IF(LEFT(B9;1)="N";1;0), finds only upper case N, the one I gave earlier finds upper and lower case N