Hi Cletus

You can use a worksheetfunction to do this
http://www.cpearson.com/excel/excelF.htm#Grades

Or on the worksheet make a list with GPA's and scores and use
A Vlookup formula


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Cletus Stripling" wrote in message ...
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!