AnsweredAssumed Answered

Validated by calculation question

Question asked by cmspe on Sep 30, 2010
Latest reply on Sep 30, 2010 by cmspe


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?