2 Replies Latest reply on Apr 11, 2013 11:04 AM by brian.bentley

    Help with If(test;result1;result2) function

    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