Wildcard characters, IF functions
 

I'm nesting a function and want to use a wildcard character (which obviously
won't work). The problem is where I have a part of a text string I'm looking
for and it's in a nested IF/AND function that's within a larger function.
IF(AND(F5="Weekly ~ Sat",A1="*hat")
Any suggestions for this portion of my function?

Wildcard characters, IF functions
 

One way:

IF(AND(F5="Weekly ~ Sat",countif(A1,"*hat")0),...



PMBO wrote:

I'm nesting a function and want to use a wildcard character (which obviously
won't work). The problem is where I have a part of a text string I'm looking
for and it's in a nested IF/AND function that's within a larger function.
IF(AND(F5="Weekly ~ Sat",A1="*hat")
Any suggestions for this portion of my function?

--

Dave Peterson