Hello and hoping you can help me! I have befuddled myself with nested IF and COUNT and feel there must be a simple solution I am not seeing, thank you for your help in advance.

I have a data set looking at outcomes and need to apply a formula to review text based evaluation (where there is a possible of 3 different values - improved, deteriorated, unchanged) across an individual row (5 columns) for the following conditions:

If there is at least one "improved", AND no "deteriorated"; return value of "better"
If there is at least one "deteriorated", AND no "improved"; return value of "worse"
If there is at least one "improved" AND one "deteriorated"; return value of "mixed"
If ALL values are "unchanged"; return value of "unchanged"

What is the best method forward?Caculation assistance.xlsx
Example partial extract attached.