I have a need where I have more than 7 conditions to check for and am
not sure the best approach to tackle the task. Any advice appreciated.

I have a range of various GPA's and want to assign a student a score
based on the range their GPA falls in.

3.94-4.0 75
3.81-3.93 70
3.68-3.80 65
3.54-3.67 60
3.40-3.53 55
3.25-3.39 50
3.10-3.24 45
2.95-3.09 40
2.80-2.94 35

So for example,
GPA Score
Student 1 3.95 75
Student 2 3.70 65
Student 3 2.80 40

Is the best approach for something like this to use visual basic? Anyone
know an easy solution?

Thanks!