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?