Hi all,
Trying to write an if formula to do the following:
If the text in cell A1 contains the word "Port", generate the word "INTERNATIONAL" in B1.
If A1 contains the word "MINE", generate the word "DOMESTIC" in B1.
I played around with a combination of an if and find formula but struggling a bit. Attached my workings
Bookmarks