View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andmor Andmor is offline
external usenet poster
 
Posts: 25
Default 400 students to grade, so little time...

I"ve collected all the marks for some 400 students and wished to convert them
from percentials into letter grades. Here is the breakdown for the letter
grades:

90 A+
85 - 89 A
80 - 84 A-
77 - 79 B+
74 - 76 B
70 - 73 B-
etc...

Now i have my percentages starting in L6 and would like to have the letter
grades starting @ M6.

I was thinking a nested if statement? please help!

--
A.