Hi - is it possible to use Wildcards in an If statement?
For example, I want to say something like:
if A2 contains "Commit" then it is an "Inside" deal; else it is a "Pipeline" deal
but if I write the following
=IF(A2="*COMMIT*","INSIDE","PIPELINE")
and A2 looks like this:
A2
this is a commit deal
then the answer is Pipeline instead of Inside.
Can you please let me know what I'm doing wrong?
Thanks
RachieD
For example, I want to say something like:
if A2 contains "Commit" then it is an "Inside" deal; else it is a "Pipeline" deal
but if I write the following
=IF(A2="*COMMIT*","INSIDE","PIPELINE")
and A2 looks like this:
A2
this is a commit deal
then the answer is Pipeline instead of Inside.
Can you please let me know what I'm doing wrong?
Thanks
RachieD