I'm looking to return text based on the content of a single, fixed cell, but I believe my syntax is bad.
Column A, Row 1 could potentially be "Q3M1W1", "Q3M2W1" or "Q3M2W3" which would be entered manually by the user.
I would like to have another cell display "M1W1" if A1 is "Q3M1W1" or "M2W1" if A1 is "Q3M2W1" or "No" if A1 is "Q3M2W3".
My formula, which is coming up unparsable is,
=IF((FIND("W1", A$1,0)), "M1W1", (FIND("M2W1", A$1,0)), "M2W1", "No")
What am I missing?
Thanks in advance.