Wildcard character in an "If" statement?
You can't directly use wildcards in an IF formula. You could use something
like this:
=IF(COUNTIF(A1:A10,"1B*"),value_if_true,value_if_f alse)
Biff
"ttretta" wrote in message
...
Can I use a wildcard character in an "IF" statement? For example, if any
of
the data in a column contains "1B*", I want to return a certain answer. I
tried typing it in that way, and it was rejected. Couldn't find the
answer
in Excel help.
Does anyone have the answer?
|