You're right! Typo! Excatly what I was looking for...many thanks!

Gord Dibben wrote:
Cletus

=LOOKUP(cellref,{0,2.8,2.95,3.1,3.25,3.4,3.54,3.68 ,3.81,3.94},{"fail",35,40,45,50,55,60,65,70,75})

where cellref is student score.

Also.......I believe you made an error in typing.

Student 3 at 2.80 would be a 35 GPA(2.80-2.94)


Gord Dibben Excel MVP

On Thu, 29 Sep 2005 16:58:33 -0400, Cletus Stripling wrote:


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!