Hello,
I was wondering If I could get help with a formula for the following table. I'm a psychologist tracking patient change, looking for a way to make data more user friendly. As you can see, I have one column with three change specifiers, an adjacent column with two severity specifiers, and then a column with six possible outputs. Is there a way to work the IF/AND functions (or another function) to enable the six results? The last error I got was that there were "too many arguments." Thanks in advance!
Conditions to Be Used for Specifier
X=Reliably Improved AND Y=Clinical Range On Track
X=Reliably Improved AND Y=subclinical Recovery
X=No Change AND Y=Clinical Range Not on Track
X=No Change AND Y=subclinical Consider Termination
X=Reliably Worse AND Y=Clinical Range At Risk
X=Reliably Worse AND Y=subclinical Psychoeducation
Bookmarks