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
Bookmarks