grading archery scores

S

Steve Gregson

please can some one help me , i am stuck on a formula for grading archers
scores.

example 1 this works ok for a one score

=IF(D31>649,"MASTER",IF(D31>549,"A",IF(D31>449,"B",IF(D31>349,"C",IF(D31>0,"D")))))

master = 650 and above
A = 550 and above
B = 450 and above
C = 350 and above
D = 0 and above

example 2 this works ok for grading over three shoots but only for two
grades

=IF(AND(A16>649,B16>649,C16>649),"MASTER","A")

MASTER = 650 and above
A = 0 and above

The problem comes when I try to get a formula to work over three shoots but
for 5 grades as above
MASTER , A , B , C , D

any help appreciated STEVE
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with a function to calculate weighted test score 2
Conditional formatting problem 3
Working out a capped point score using LARGE function 2
Can Text be Treated as Values for use in Calculations with Numbers? 3
Creating a Function Problem 4
changing score from number to letter grade 3
2 Dimensional Lookup by column & rows to return score grade 2
Excel 2002 : Any single button to get sub total and grand total ? 2

Top