Ron, I also have a similar scoring problem for one shoot that will score points no matter what the score is. The shoot's score will be entered in Cell F6.

445-450 = 6 pts, 432-444 = 5 pts, 409-431 = 4 pts, 365-408 = 3 pts, 310-364 = 2 pts, 0-309 = 1 pt

This will be entered into Cell Z6.

Thanks,

Kyle