Posts by juansonofsmith

    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.