2 Replies Latest reply on Sep 30, 2010 1:48 PM by cmspe

    Validated by calculation question



      Validated by calculation question


      As a teacher, I accidentally will enter an incorrect score that I won't avoided using validation.  No one runs a sub 5:00 mile run so I've validated data entry into this field by requiring it to be "In range: 500 to 2000" (I'm not using the : for the mile scores).  However, we enter a zero for anyone who is absent.  Therefore, I am trying to use the "validated by calculation" method, but am stumped at how to calculate that.  Any suggestions?