Wildcard character in an "If" statement?
Your best option is probably something like
=IF(LEFT(A1,2)="1B",2,3)
"ttretta" wrote:
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?
|