Thread: How do I convert A-E grades to number averages?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abigail Abigail is offline
external usenet poster
  
Posts: 10
Default How do I convert A-E grades to number averages?
I enter grades into Excel in an A-E format. I would like to create a number
average, where A+=1, A=2, A-=3 etc, so that it picks up an A, B+ and C-
average out to a numerical value of 5, which I could therefore give a B
overall to. Have wasted valuable hours on this.
Reply With QuoteReply With Quote