IIF Function
If you don't want to use VBA:
=IF(C2<78.1,"GD5",CHOOSE(MATCH(C2,{78.1,84.2,89.3, 96.2},1),"GD4","GD3","GD2","GD1"))
--
Regards,
Tom Ogilvy
"John" wrote in message
...
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. How do I automatically populate a grade cell for each person
based on there scores?
Is an IIF function the best method here? if so how would I code this?
Please help if possible.
Kind Regards
John
|