Forum Discussion
NitaBee
Apr 20, 2022Copper Contributor
IF formula with inclusion / exclusion criteria for text?
Hi all, I'm struggling with some text based formula prep. I would like to figure out how to put a formula together that tells me if there are normal regular non-golden/silver apples (in singular o...
mtarler
Apr 20, 2022Silver Contributor
I was going to suggest something else but actually like your approach and just add the case that Apple is how it starts:
=IF(COUNTIF(A2,"*, Apple*") + (Left(A2,5)="Apple"), "yes","no")
=IF(COUNTIF(A2,"*, Apple*") + (Left(A2,5)="Apple"), "yes","no")