View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga
 
Posts: n/a
Default electronic gradebook

Nel post
*shug* ha scritto:

how do i put in the formula to get a letter grade by using
percentage. for instace 100 - 90 = A
89 - 70 = B and so on using Excel.


You can use VLOOKUP with last parameter set to TRUE. You have to build a
table, in ascending order of values, and then use the VLOOKUP function.
--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy