View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excelguy[_2_] excelguy[_2_] is offline
external usenet poster
 
Posts: 27
Default letters having values

I have a list of students with grades ranging from A+ to F. How can I make
Excel calculate an A+ to equal 4 points and multiply it by the number of
credits taken. For example:

Name Grade Credits Total
John Smith A+ 3 12