I am trying to use gender and age to look up a score on a scale. My class is
co-ed with 6-12 year olds. There are different grading scales for each
gender and age.

Jonny male age 6 ran a mile in 12 minutes.....I want to look up his 12
minute mile on a scale to reward him with a grade. How do I write a formula
to use gender age and a score?

Susie female age 10 ran a mile in 10:33....I need to look up a completely
different scale for 10 year old female.....

HELP!