Hi,
I am trying to create an IF statement but am struggling to make it work properly.
I have my column B which has a code - for example TD12345 or RE12345
I am trying to make an IF statement for my column C to display a certain text depending on column B
Specifically, I am trying to make it so that
IF column B contains TD put OP in column C
IF column B contains RE AC or MA put IP in column C
IF column B contains ER put ER in column C
I think it is the second criteria which is screwing up my formula where you have three scenarios that results in one thing. Can anyone help me? Thank you.
Bookmarks