2 Replies Latest reply on Dec 3, 2012 9:44 AM by philmodjunk

    School Grades in a calculation

    PattyKelly

      Title

      School Grades in a calculation

      Post

           Hello, 

           I'm trying to do a calculation that simply states - that

           if a student has a GPA lower than a 2.5

           and/or

           has an ACT score lower than 20 - that the end result is "bad grades".  I'm close with the calculation:

           If ( (0≤ ACT and ACT <20) or (0≤ GPA and GPA <2.5); "bad grades";"")

           But, I keep getting "bad grades" if there is nothing entered in one of the fields.  Yes, I checked the box that says do not calculate if field is empty, which I thought was fixed with the 0≤ - but it's not.  

           Any help, greatly appreciated.  

           Thanks, Patty