For example:

1.If bad number is submitted
2. If any score is 500
3.If any score is below 100
4. If two column's average 200...

I can do the formula's to give the above information but I do not know how
to apply the above in order of preference as in 1, 2, 3, 4 (above) Thanks for
any help