I have a very simple column of text which is a result of some if functions. Now I want to choose one word depending on the condition. My column might look like this depending on the condition of the input.
red
green
green
yellow
yellow
How can I have a formula to return:
IF "red" anywhere in the column return red
IF no "red" then check for "yellow" and return yellow.
IF only green then green
Super simple I know, but I'm stuck.
Thanks
Michele
red
green
green
yellow
yellow
How can I have a formula to return:
IF "red" anywhere in the column return red
IF no "red" then check for "yellow" and return yellow.
IF only green then green
Super simple I know, but I'm stuck.
Thanks
Michele