IF AND ELSE THEN statements - learning curve

[MaryCann]

Hello Alteryx community!  New to SQL here...  Scenario:  some patients are on AntiPsychotic medications as well as non-AntiPsychotic medication.  If a client is on Anti-Psychotic Medication I want the result to be "Client on Antipsychotic Medication" even if only 1 of their 10 medications is an AntiPsychotic...  As well as if they are on no AntiPsychotics, I want it to be "Not on AntiPsychotic Medication"My first formula here works, but, the second one does not...  What do you recommend?

[MaryCann]

IT WORKED IT WORKED IT WORKED!!!  THANK YOU THANK YOU THANK YOU!!!!!!!

[FloraF]

AWESOME!!!!! I am glad to hear Mary.

Having Solving from Team Alteryx :)