1. ## Unit Grades (Excel 2003)

hi there, S12 shows the overall results for the questions and assignment results from F12:R12. so using S12 i want to determin the distinction, merit, pass, fail mark to be entered in cell T12 unit grade, i have left my attempt in the box for now so you can see i am trying. regards kitty

2. ## Re: Unit Grades (Excel 2003)

I think you got the > and < wrong: Do you mean:
=IF(S12>=75,"D",IF(S12>=60,"M",IF(S12>=40,"P","F") ))

But instead of putting all the numbers explicitly in the formula, the lookup suggested earlier is easier to maintain:
=INDEX(\$K\$3:\$N\$3,MATCH(S12,\$K\$4:\$N\$4))

Steve

3. ## Re: Unit Grades (Excel 2003)

THANKS ALSO IT WORKED A TREAT, I WILL TRY THE VLOOKUP TABLE NEXT TIME.

4. ## Re: Unit Grades (Excel 2003)

Hey Kitty,

Go easy on the Caps Lock - posting in ALL CAPS is the Internet equivalent of shouting. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•