I have some data which are grouped like this:
1st group of data(gender): Male, Female 2nd group of data(age): 12,13,14,15 3rd group (score + grade): For each gender and their corresponding age, there is a range of the scores grade A,b,c,d
For example: For a 12yr old male, 40 points will correspond a C grade. While a 14yr old female, 50 points will correspond a B grade.
how can i use excel to help me such that when I enter the age, gender and score, the correspond grade will come out?
THank you so much.