Formulas : Using Wildards in If Then formulas

  • I'm trying to write an If / Then statement that will check to see if a particular word is contained in a cell. The Cell could have several words and I'm only looking for one.

    I've tried using the *(wildcard) but it doesn't give me the correct answer.

    =IF(B2 = *"PB"*, "PB", "Other"

    The above formula always gives an "Other" answer.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!