10 Replies Latest reply on Sep 13, 2018 10:44 AM by Hari Ankem

    How to Create a Calculation with IF and OR and AND statements

    Rashida Kimbrue

      Hi,

       

      I am attempting to create a calculation with IF and OR statements, however, my calculations contain errors and I'm unsure on what to fix. I am trying to create the following statements using testing percentile scores and have attempted to create number 1:

       

      IF AVG([M. Attainment1]) OR AVG([R. Attainment1])>90 THEN "R or M Topline"END

      ELSEIF  AVG([M. Attainment1])OR AVG([R. Attainment1])<90 AND >50 THEN

      "Below R or M Topline"

      END

       

      1. 90%ile or above in ONE of reading & math (other >= 50) Worksheet 1

      2. 90%ile or above in ONE of reading & math (other >= 70) Worksheet 2

      3. 70%ile or above in ONE of reading & math (other >= 50) Worksheet 3

       

       

      Thanks for your help.

       

      Rashida