AnsweredAssumed Answered

Help with If(test;result1;result2) function

Question asked by brian.bentley on Apr 11, 2013
Latest reply on Apr 11, 2013 by brian.bentley

Title

Help with If(test;result1;result2) function

Post

     I am working with the "If(test;result1;result2)" function. Is there a way to include several different tests in the same formula? I have tried using OR and AND, but it doesn't seem to work:

     If ( Class Name = "Swimming" ; "Healthy Lifestyles" ; "" )  works.

     If ( Class Name = "Swimming" or "Basketball"; "Healthy Lifestyles" ; "" ) does not work.

     I know I can stack formulas with &; just wondering if I can combine the formulas into one.

     Any help would be greatly appreciated.

     Thanks, Brian

Outcomes