multiple IIF functions

[John]

Hi,
I am working on an Office 2003 worksheet which determines a grade for users.
Grades are based on scores and are graded as shown below.

GD1 GD2 GD3 GD4
GD5
96.2 and above 89.3 and above 84.2 to 89.2 78.1 to 84.1 78.0 and
below

I have a total score for each person i.e. 86.8 which would put this person
into GD3


Is an IIF function the best method here? if so how would I code this?

Please help if possible.

Kind Regards

John

 

[RichardSchollar]

Hi John

You can do this easily with a LOOKUP such as:

=LOOKUP(A1,{0,"GD5";78.1,"GD4";84.2,"GD3";89.3,"GD2";96.2,"GD1"})

where A1 holds the value you want to ascribe a grade to.

Hope this helps!

Richard

 

[Ragdyer]

With scores entered in A1, try this:

=LOOKUP(A1,{0,78.1,84.2,89.3,96.2;"GD5","GD4","GD3","GD2","GD1"})

 

[Guest]

=LOOKUP(A1,{0,78.1,84.2,89.3,96.2},{"GD5","GD4","GD3","GD2","GD1"})